MySQL Performance Blog

As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see Heikki and the Team were not just doing only bug fixes for last two years, but rather kept very quite.

We had access to this code for few weeks and should say we were impressed in quality (we found only one crash bug which was fixed in less than 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly released we’ll try to put it to some production slaves to see how well it works.

There are still usability issues with this release (which you can blame both MySQL and Innodb for) - for example neither of standard data load tools (mysqldump import, using LOAD DATA INFILE or ALTER TABLE from other storage engine) would use Fast Innodb Index creation. Keep it in mind if you decide to benchmark/compare it.

If you would like to learn more about this Plugin you’re welcome to come to presentation by Heikki and Ken
which will be followed by my presentation on Innodb Scalability Limits. I will not go a lot into this plugin performance because I did not know when it would be released until very late and so if I can show any benchmark numbers for it at all. But still there are some and they are pretty cool.

P.S I’m also very happy to see Innodb continues to provide full Server functionality under GPL License.