The MySQL 5.5 (and 5.6) documentation says, in Identifying the File Format in Use:

“… Otherwise, the least significant bit should be set in the tablespace flags, and the file format identifier is written in the bits 5 through 11. …”

This is incorrect for any version due to a bug in how the tablespace flags were stored (which caused only 1 bit to be reserved, rather than 6). This was all re-worked in MySQL 5.6, so someone obviously noticed it, but the documentation has been left incorrect for all versions, and the incorrect and misleading code has been left in MySQL 5.5. I filed MySQL Bug #68868 about the documentation.

File formats and names

There are file format names in the documentation and code for values 0 through 25 (letters …

MySQL 5.6 through the eyes of a custom storage engine MySQL plugin

MySQL is famous for its pluggable storage engine architecture which allows a DBA or an application developer to choose the right engine for the task. An application uses MySQL API and is isolated from all of the low-level implementation details at the storage level. As an example, the Cloud Storage Engine (ClouSE) enables existing MySQL applications to use cloud storage such as Amazon S3 or Google Cloud Storage to store its data. The application doesn’t need to be changed or even redeployed: with ClouSE, remote cloud storage will look like a better (ultra-scalable, durable, always-on) alternative to the local storage.

As you may already know, ClouSE now supports MySQL 5.6 release …

Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!

As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.

But of course, we’re getting particularly excited as we prep for the 2nd annual SkySQL and MariaDB MySQL & Cloud Database Solutions Day, which takes place on the day (Friday, April 26) right after Percona Live: MySQL Conference and Expo.

read more

Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!

As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.

But of course, we’re getting particularly excited as we prep for the 2nd annual SkySQL and MariaDB MySQL & Cloud Database Solutions Day, which takes place on the day (Friday, April 26) right after Percona Live: MySQL Conference and Expo.

read more

Collaborate is a huge show that is the Independent Oracle User Group’s big yearly show and for 2013 it will be in Denver. There are several MySQL sessions of note and I have noted some below. By the way i will have new MySQL stickers available at the MySQL Demo Pod on the show floor but rules say I can not just leave them around — you will have to ask for them.

• Session #464 – Demystifying MySQL for Oracle DBAs and Developers
  Mon. Apr. 8 11:00 am – 12:00 pm
  Mile High Ballroom 2C

  Abstract: MySQL continues to be the world’s most popular database management system for the Internet. This session provides a fast-paced introduction to the MySQL architecture, core features, best practices, and core performance areas. A MySQL version of OFA will be shown as a best practice. MySQL features will be taught from a perspective that is easy for attendees …

In the past… One of the typical problems you have when restarting mysqld is that the InnoDB buffer pool (buffer pool from now on) is empty and consequently access to the database requires reading directly from disk. Performance suffers dramatically as a consequence.

So the common solution is to artificially warm upthe server by doing queries which will fill the buffer pool. Typical solutions might be to do: SELECT COUNT(*) FROM some_table FORCE INDEX (PRIMARY) LIMIT ... on a number of tables to fill up the pool on startup. Fitting this into the standard mysql init start script is somewhat tricky as no hooks are provided for this sort of post-start action. (It would be nice to have this for other tasks too.)

Of course choosing the right parameters here can be tricky as workload changes over time, and as the ratio of the size of the database to the size of the buffer pool increases, you need to be more selective …

I’ll be at Percona Live to give a keynote on the latest innovations we are doing with MySQL. Also learn about the latest from the MySQL Engineers on InnoDB, Replication, and Performance

I’m really looking forward to Percona Live this year. I will be there, along with Kyle Redinger, my co-founder at VividCortex. I feel that this year the conference has come full circle. 2007 was my first year at the conference, and it was amazing. This year is tremendously exciting for me because it feels like we’re back on the 2007 trajectory.

Those were the golden days. Things were a little sad in 2010 and 2011 as the MySQL community tried to figure out the new landscape and O’Reilly decided to stop running the event, but then in 2012 we all said “we’re back!” with the exception of Oracle, who instead arranged MySQL Connect, as part of Oracle Open World. I don’t think that was a huge success. I don’t know if that’s why Oracle has decided to participate in this year’s Percona MySQL conference, but frankly it …

This is my 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back in 2003), and for me it does not get tiring. So what is there in this conference for me as an attendee, speaker and businessman?

Learning. First and foremost the conference is still a great learning venue for me. I learn about new technologies in the MySQL space as well as how these technologies can be applied in practice. I learn what works and what does not. I learn from the sessions, expo hall exhibitors and hallway conversations. I’m glad that over so many years the conference is still …

Join us for MySQL Connect and submit a paper