June 19, 2013

Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo

… Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6…, VP Architecture, Monty Program Ab Topic: “Storage Engines and Other Plugins: What’s New?” The Percona Live MySQL Conference includes a…

Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage

… results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions per minute, more is better) : As you see InnoDB-plugin is… for InnoDB-plugin. Here we observe innodb_adaptive_flushing in action (which is ON by default), and I think innodb_adaptive_flushing in InnoDB-plugin is…-9 26160.551 NOTPM InnoDB-plugin is 1.6x times better InnoDB, and XtraDB is 1.7x times better InnoDB-plugin. Now on CPU usage…

Post: Innodb plugin 1.0.4 released - great job Innobase

… exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released… adopter” version of a plugin which is a bit of disappointment as we can’t wait for Innodb plugin to become stable/GA… fun part starts – we need to evaluate/benchmark/stress test Innodb Plugin 1.0.4 to integrate it with next XtraDB release.

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

… so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent… regression from plugin increases with number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format… execution path. Another thing to note – if you’re using Innodb Plugin consider using new Barracuda format, though do this only after…

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

… bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no particular reason except…_innodb.cc:2284) ==9090==    by 0x712F17: ha_initialize_handlerton(st_plugin_int*) (handler.cc:435) ==9090==    by 0x7A212A: plugin_initialize(st_plugin_int*) (sql_plugin

Post: How to Monitor MySQL with Percona's Nagios Plugins

… its data directory. InnoDB is getting stuck, has long-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses…

Post: Great work Innodb Team

… fixed now. Innodb plugin documentation now seems to be merged with MySQL Documentation which makes it much more usable and Innodb Plugin is shipped… Percona were reworked and included in the plugin during latest months. We can also see Innodb Plugin 1.0.5 is named Release… public release and probably 4 years since the work on Innodb plugin features such as compression or Online index creation has started…

Post: MySQL and plugin binaries

… and binaries of third-party plugins. I personally found and there is confirmation from InnoDB team that current InnoDB-plugin binaries do not work… incompatible binary on the second day after the announce of InnoDB plugin. I do not think it was intentional, but still looks… current API “versioning binds a plugin binary to specific server release”. That simply means that InnoDB has to release binary for each…

Post: Real-Life Use Case for "Barracuda" InnoDB File Format

… new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could… convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was… is trying to compress 16kb pages down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off-page so every…

Post: Interested to learn about New Innodb Plugin Performance ?

As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see … 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…