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.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.