…: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 is a signal… MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO… asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it is…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…; you just have to pay for the plugin if you want the official Oracle one;… improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5… personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
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 know…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and… times better InnoDB-plugin. Now on CPU usage and disk utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs less 150MB… can have very impressive performance improvement in IO-intensive or IO-bound workloads. You may want to use InnoDB-plugin or XtraDB to…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent… execution path. Another thing to note – if you’re using Innodb Plugin consider using new Barracuda format, though do this only after… between CPU usage and performance. We can see Plugin uses less CPU with 8 cores and has less performance – this usually shows synchronization…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… 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 large…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… 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… serialized in memory after the reset. A speculative processor might perform the read first, which could leave a waiting thread hanging…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
…. There is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb plugin 1.0.3… with relevant performance changes instead ? This would highlight it status as future Innodb code base. Now I’m confused – if Innodb Plugin is not taking place of default Innodb in MySQL 5…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… 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… that can be performed with existing plugins, so there was no need to write new ones. For example, the plugins that ship with…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
… of our interest which is Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5… 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…
