Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 91 to 120 of 267 Next 30 Older Entries

Displaying posts with tag: skysql (reset)

How to Build MySQL 5.6 on Windows from Source Code
+2 Vote Up -0Vote Down

I just set up a new Windows 7 machine, and built MySQL 5.6 for the first time, so I wanted to share my steps for anyone interested.

** Prerequisites **
1. Install Microsoft Visual Studio (I installed VS 2010 Express – free)
2. Install cmake
3. Install bison (make sure no spaces in path)

** Build Instructions **

cd c:\mysql\mysql-5.6.10
mkdir bld
cd bld
cmake ..
cmake --build . --config relwithdebinfo --target package

(You don’t technically need the ‘bld’ dir, but I prefer it to keep the main dir ‘clean’. Then if you need to re-build, you can quickly just delete the whole ‘bld’




  [Read more...]
How to Build MariaDB 10.0 on Windows from Source Code
+2 Vote Up -0Vote Down

I just wanted to share my steps for building MariaDB 10.0 on Windows (10.0.1 in this case):

cd maria-10.0.1
mkdir bld
cd bld
cmake .. -G "Visual Studio 10"
cmake --build . --config relwithdebinfo --target package

That’s it! The zip file is created right there in bld/.

Hope this helps.

 

SkySQL & MariaDB’s 2nd Annual MySQL & Cloud Database Solutions Day
+1 Vote Up -0Vote Down

As the press release says: “Come have a (free) beer with Monty: SkySQL & MariaDB’s 2nd Annual MySQL & Cloud Database Solutions Day”!

“Are you planning on being in Santa Clara for Percona Live: MySQL Conference and Expo in April? If so, don’t let the learning and networking stop on Thursday!

We invite you to join SkySQL & MariaDB for our 2nd Annual MySQL® & Cloud Database Solutions Day, Friday, April 26, 2013 at the Hyatt Regency Santa Clara. This event will be taking place directly after the Percona Live event.

During this free one-day event, you will receive hands-on training and consulting on MySQL and MariaDB database solutions from the experts at SkySQL, MariaDB, and their partners.”

Speakers will include Big Data, Analytics and Cloud experts, as well as SkySQL customers and MariaDB users. Including:

Monty Widenius

  [Read more...]
Enabling the Verbose InnoDB Lock Monitor in MariaDB and Percona Server for XtraDB+ and XtraDB
+0 Vote Up -0Vote Down

I enabled the InnoDB Lock Monitor in my MariaDB 5.5 instance (using XtraDB+ as the InnoDB – which is the default in MariaDB) and noticed that while the SHOW ENGINE INNODB STATUS was being logged to the error log, it wasn’t logging the “additional” lock information – it just looked like the plain ‘ole INNODB STATUS.

Long story short, Percona added a new variable so one has better control over what gets logged:

innodb_show_verbose_locks

If off (default), then the InnoDB Lock Monitor logs the normal INNODB STATUS, and if enabled, then it logs it with the extended lock information.

They also created another variable that goes along with this one (and the InnoDB Lock Monitor), which is:

innodb_show_locks_held

This

  [Read more...]
Exciting Group of Speakers for MySQL & Cloud Solutions Day, Friday, April 26th in Santa Clara
+1 Vote Up -0Vote Down

Agenda includes speakers from Calpont, Codership/Galera, Craigslist, MariaDB, SkySQL and the OpenStack Foundation

Today, SkySQL and MariaDB jointly announce an exciting lineup of speakers for their MySQL and Cloud Solutions Day on Friday, April 26th, at the Hyatt Regency Santa Clara. This year’s agenda will feature database and cloud tutorials, as well as keynotes, featuring speakers from Calpont, Codership, Craigslist, MariaDB, SkySQL and the OpenStack Foundation.

read more

Exciting Group of Speakers for MySQL & Cloud Solutions Day, Friday, April 26th in Santa Clara
+0 Vote Up -0Vote Down

Agenda includes speakers from Calpont, Codership/Galera, Craigslist, MariaDB, SkySQL and the OpenStack Foundation

Today, SkySQL and MariaDB jointly announce an exciting lineup of speakers for their MySQL and Cloud Solutions Day on Friday, April 26th, at the Hyatt Regency Santa Clara. This year’s agenda will feature database and cloud tutorials, as well as keynotes, featuring speakers from Calpont, Codership, Craigslist, MariaDB, SkySQL and the OpenStack Foundation.

read more

Dealing with the dreaded “The printer is out of paper” or ERROR_OUT_OF_PAPER Error on Windows ;)
+3 Vote Up -0Vote Down

Caution: This is just a fun post.

I was performing some testing on Windows the other day and encountered the following error in the error log:

130313  9:40:03 [ERROR] Error writing file 'G:\mysql\log.txt' (errno: 28)

Quickly, I ran “perror 28″ from the command line:

c:\>perror 28
Win32 error code 28: The printer is out of paper.

Hehe, really, Windows?!?

In fact, the drive was out of space. No more could be written to the general log, hence the error.

Fwiw, the Linux OS code 28 reports what you would expect:

OS error code  28:  No space left on device

So, if you ever run into “The printer is out of paper” error, you’ll know what to do.

 

InnoDB Plugin Version Numbering in MySQL and MariaDB
+2 Vote Up -0Vote Down

As some of you may or may not know, I’ve maintained a list of all InnoDB Plugin versions as they’ve historically contained a different version (entirely different numbering scheme) than the MySQL distribution they were included with.

This list was most helpful for troubleshooting various InnoDB issues when the plugin may (or may not) have been involved, and/or for benchmarking, etc. And it’s fair to say it was more useful when the InnoDB plugin was not the mainstream, which it is now.

However, with the latest releases, in MySQL and MariaDB, the “InnoDB Version” simply matches the “MySQL Version”. These “latest releases” include: MySQL 5.6.10, MySQL 5.5.30, MySQL 5.1.68, and MariaDB 5.5.30

Of course this isn’t the most newsworthy story, but having maintained this

  [Read more...]
Troubleshooting MySQL Crashes related to Metadata Locking
+2 Vote Up -0Vote Down

I just wrote an article about “Troubleshooting ‘Waiting for table metadata lock’ Errors for both MyISAM and InnoDB Tables” and then ran into a new, different metadata locking issue right after I posted it, and so I thought I’d share that too, just in case anyone ever encounters a similar situation.

In this case, mysqld kept crashing on restart, reporting “out of memory” errors:

/opt/app/mysql/product/mysql/bin//mysqld: Out of memory (Needed 840 bytes)
stack_bottom = 7fb4ebaeae58 thread_stack 0x40000
mysqld: /mysql/mysys/my_new.cc:52: int __cxa_pure_virtual():
  Assertion `! "Aborted: pure virtual method called."' failed.
mysqld: /mysql/mysys/my_new.cc:52: int __cxa_pure_virtual():
  Assertion `! "Aborted: pure virtual method called."' failed.
Fatal signal 6 while backtracing

There is a

  [Read more...]
Troubleshooting “Waiting for table metadata lock” Errors for both MyISAM and InnoDB Tables
+1 Vote Up -0Vote Down

With the introduction of metadata locking in MySQL 5.5, it is much more common to see queries stuck in the “Waiting for table metadata lock” state.

If you see a query stuck in the “Waiting for table metadata lock” state, waiting for a MyISAM table, then it is because this table has been included as part of some uncommitted transaction (whether intentionally or not).

In fact, it could be as simple as issuing SET AUTOCOMMIT=0 followed by a SELECT against a MyISAM table (a transaction can be started 3 ways: START TRANSACTION, BEGIN, and SET AUTOCOMMIT=0). After that, the table will be locked to other DDL statements until the transaction is committed (or ended).

This metadata lock is meant for DDL statements, and so that is what it blocks. However, once a DDL





  [Read more...]
Tracking down strange “Can’t find file” (ER_FILE_NOT_FOUND) Errors
+2 Vote Up -0Vote Down

Ever see an error like this in your console or error log, respectively, and wonder where it originated from?

Console (5.5.30):

ERROR 1017 (HY000): Can't find file:
'.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22)

Error Log (5.5.30):

130307 23:22:04 [ERROR] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: 
Can't find file: '.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22)

(Fwiw, they are harmless, unless it is indicative of some sql injection – but you may want to sanitize your data better, unless it’s just a one-time user error. Also, if you’re seeing it from the command line, then you’ll likely realize what you did immediately, and thus no need to ‘figure out’ what happened. However, when you *only* see this entry in the error log, and you want to know how that happened after the fact, then this is more

  [Read more...]
MySQL Events
+3 Vote Up -0Vote Down
The last MySQL User Group NL meeting was last Friday. It's always nice to learn about MySQL and meet other MySQL users. There were two presentations: one about MySQL User Defined Functions (UDF's) and one about MySQL TCO. The slides are available from the meetup page.

There are already a number of MySQL events announced for the next few months. I'll only list events in the Netherlands and Virtual events.

MySQL Virtual Developer Days
This is a virtual event which will take place on March 19 (EMEA region, NA event is on March 12). There are many interesting topics: Performance Schema, New 5.6 Features, Replication, MySQL Enterprise Monitor
The eVite

SkySQL and MariaDB roadshow
21 March 2013 in Amsterdam
This event  have









  [Read more...]
Brush Up Your MySQL Skills, Including Transitioning to the Cloud, and Meet the SkySQL Team!
+2 Vote Up -0Vote Down
Latest training events calendar & class schedule now available

read more

The SkySQL and MariaDB Meetup in Amsterdam - with Monty Widenius, the 'father' of MySQL®
+5 Vote Up -0Vote Down

SkySQL and Monty Program are on the road with our joint Meetup in Amsterdam where Monty Widenius - the origninal creator of MySQL - will unveil his vision of the future of the MySQL database via MariaDB.

Seppo Jaakola from Codership will give a presentation about Galera Cluster for MySQL and MariaDB.

In addition we will have speakers from Booking.com as well as Anders Karlsson from SkySQL who will talk about Big Data.

read more

Meetup SkySQL & MariaDB à Paris en présence de Monty Widenius, créateur de la base de données MySQL®
+2 Vote Up -0Vote Down

Le 27 mars de 14h à 19h à l'Atelier du France, Paris

SkySQL et Monty Program organisent une demie journée de conférences consacrées aux bonnes pratiques et retours d'expériences autour des bases de données MySQL®et MariaDB, l'objectif étant de répondre aux préoccupations actuelles des administrateurs de bases de données.

read more

MySQL 5.6 vs. MariaDB 10.0
+6 Vote Up -8Vote Down

A high-level comparative overview of the features

With the recent GA release of MySQL 5.6, there have been a lot of questions about where MariaDB stands with regards to MySQL 5.6.  SkySQL will of course support both as Patrik explained in his recent blog post, but there are many questions about the technical differences. Rasmus from Monty Program gave a detailed view on MariaDB 10.0 here but I thought it would be beneficial to share a comparison table of the two. MariaDB recently released a benchmark including various versions of both MariaDB and MySQL (as did DmitriK from Oracle), but this post will focus solely on

  [Read more...]
[Plus] readers choice 2012 : Final results
+2 Vote Up -0Vote Down

It’s time to unveil the winners of the [Plus] readers choice awards!
Thank you again for your votes, remember that the real winner was the community, again.

I asked you to vote for what you used in 2012 and you’ve voted with your heart.
Here are the final results, congrats to the lucky guys and teams :

The most useful blogs in 2012 :

  • MySQL Performance Blog
  • The MariaDB Blog
  • SkySQL Blog
  • Ok, the Percona team members provides the best technical blog about MySQL (and more), this year again. Of course, this blog is very useful and interesting, I recommend to read the comments too, they are often very informative.



      [Read more...]
    What to See & Do at Percona Live: MySQL Conference & Expo 2013
    +3 Vote Up -0Vote Down

    It’s not too soon to be thinking about what sessions you’ll be attending while at Percona Live: MySQL Conference & Expo 2013. SkySQL’s team of MySQL and MariaDB database experts will be headed to Santa Clara in full force as sponsors and speakers of this annual meeting for MySQL database users. As you plan out your week, be sure to check out some of SkySQL’s talks, including:

      [Read more...]
    Congratulations on the GA release of MySQL 5.6!
    +6 Vote Up -7Vote Down

    Tuesday, February 5th was an important day in the MySQL ecosystem due to the release by Oracle of the long-awaited MySQL 5.6 GA. Many MySQL users have been looking forward to this release in order to benefit from the improved performance and scalability. Features such as online operations/schema changes, NoSQL access from memcached to InnoDB, multi threaded-replication and Global Transaction ID significantly improve the competitiveness of MySQL.

    read more

    SkySQL and MariaDB Announce 2nd Annual MySQL & Cloud Solutions Day, Friday, April 26, 2013
    +1 Vote Up -0Vote Down

    The MySQL & Cloud Solutions Day will take place at the Hyatt Regency Santa Clara, immediately following the Percona Live:  MySQL User Conference & Expo 2013

    During this one day event, Monty Widenius and Patrik Sallner, SkySQL CEO, will share insights on the current and future trends pertaining to MySQL, MariaDB 10.0, and the Cloud.  The event will feature two technical tracks:  one focused on the MySQL database and related technologies, and a second on best practices for deploying database applications in the Cloud.  Speakers will also include SkySQL and MariaDB customers, users and

      [Read more...]
    MariaDB Expanding Its Reach
    +9 Vote Up -5Vote Down

    The news is already making the rounds (ex: rumors here, and confirmed here and here), but Fedora will apparently replace MySQL with MariaDB in an upcoming release.

    read more

    SkySQL and MariaDB Announce 2nd Annual MySQL & Cloud Solutions Day, Friday, April 26, 2013
    +0 Vote Up -0Vote Down

    The MySQL & Cloud Solutions Day will take place at the Hyatt Regency Santa Clara, immediately following Percona Live: MySQL User Conference and Expo 2013

    read more

    SkySQL Solutions Day, FOSDEM MySQL activity
    +4 Vote Up -0Vote Down

    February is turning out to be a busy month. I’ll be giving a talk about MariaDB at the SkySQL Solutions Day in Hamburg, alongside Sergei Golubchik. This happens February 1 2013.

    I’ll also be in Brussels for FOSDEM and presenting at the MySQL & Friends devroom. Here I will talk about MHA and how you can get automated MySQL failover. I’ll also be hanging out at the CentOS booth with Karanbir Singh giving away MariaDB stickers all weekend. If you’re at FOSDEM, don’t forget to sign up for the

      [Read more...]
    Talking at the SkySQL Roadshow in Stockholm
    +3 Vote Up -0Vote Down
    SkySQL Roadshow is coming to Stockholm on Feb 7, come by and meet us. I'll be ending the day with a talk on Big Data, which will be a more generic Big Data talk with some MySQL relevance, but with the focus on Big Data in general.

    I haven't blogging much recently, but that has some reasons. I am since Dec 1 the proud father of twins, a little boy and a little girl. I have yet to teahc them to write proper SQL, the have particular issues with subqueries, but we'll get there. In order to create the usual mess of things and to make sure things are at the brink of running out of control, we decided to renovate our flat in the middle of all this. But I'll get there, and once we have a new kitchen installed, I'll do some more blogging, I have some things piled up to write about.

    /Karlsson
    SkySQL has been named one of the Top 20 Startup Companies in Finland
    +2 Vote Up -0Vote Down

    We're looking forward to spreading the MySQL, MariaDB & Cloud message further in Finland this year!

    Talouselämä, the largest Finnish business publication today published their list of the Top 20 Startup companies in Finland. The selection was made from approximately 100 applications from companies based in Finland. 

    read more

    Is Onsite Training Right for You?
    +2 Vote Up -2Vote Down

    Our customised training courses for the MySQL & MariaDB databases help your team learn exactly what they need to know

    Since SkySQL’s inception, training has been an integral part of the services we provide. Training isn’t just something we offer, but an intrinsic aspect of our business model as we evolve into an all-inclusive service and product provider. And customized onsite training is the best way your team learns what your specific team needs to know.

    read more

    SkySQL and MariaDB After Work Meetup with Monty Widenius, the "Father of the MySQL® & MariaDB Databases"
    +4 Vote Up -2Vote Down

    The SkySQL and MariaDB Roadshow comes to Sweden:

    Stockholm 7 February 2013, 16:30-19:30, Dramaten Restaurang Pauli

    SkySQL and Monty Program are on the road with our joint - free - roadshow in Stockholm where Monty Widenius will unveil his vision of the future of the MySQL database via MariaDB.

    In addition, we will have speakers from Codership/Galera, as well as SkySQL experts.

    read more

    [Plus] readers choice 2012 : It’s time to vote!
    +2 Vote Up -0Vote Down

    Oh yes, 2012 was an incredible year for the MySQL Community!
    That’s why I would like to change the rules this year and I would like to offer you a new survey for this [Plus] reader’s choice 2012.

    Community users, bloggers and events made the whole community last year, tell us how you used this community?
    It will only take 5 minutes of your precious time, votes will be closed Jan. 31.

    Vote for what you used! (with your heart, again…)

    Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit

      [Read more...]
    MySQL® & Cloud Database Solutions Days with Monty Widenius, the “father of the MySQL® & MariaDB databases”
    +3 Vote Up -0Vote Down

    The SkySQL and MariaDB Roadshow Comes to Germany:

    Stuttgart 25 January 2013, 9.00-16.00, Sodexo STEP / Engineering Park

    Hamburg 1 February 2013, 9.00-16.00, Quality Ambassador Hotel

    SkySQL and Monty Program are on the road with our first joint – free – roadshows in Stuttgart and Hamburg, where Monty Widenius will unveil his vision of the future of the MySQL database via MariaDB (the talk will be in English).

    In addition, speakers from Codership / Galera expected, as well SkySQL experts and customer speakers.

    The latest

      [Read more...]
    A few great weeks for MariaDB
    +2 Vote Up -4Vote Down

    I think MariaDB has had a great few weeks recently and the timeline of these events are important.

  • 27 November 2012 – WiredTree Adds MariaDB for Faster MySQL Database Performance (well worth reading their motivations to switch)
  • 29 November 2012 – Monty Program & SkySQL release the MariaDB Client Library for C & Java
  • 4 December 2012 – MariaDB Foundation is announced, see ZDNet coverage.
  • mid-December 2012 – Wikimedia Foundation starts migrating
  •   [Read more...]
    Previous 30 Newer Entries Showing entries 91 to 120 of 267 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.