…we are a little slow to blog about this and acknowledge the…just have to pay for the plugin if you want the official Oracle… partitioning, and the addition of multiple InnoDB buffer pools. Best of all, …with different characteristics, and feature and performance improvements are moving rapidly forward …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…blog post, and explain the need to be careful with them. Although we’re not finished with the plugins…-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, …performed with existing plugins, so there was no need to write new ones. For example, the plugins…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… get stable performance (as you may see from Dimitri’s post, http://dimitrik.free.fr/blog/archives/2010/12/mysql-performance-analyzing-perconas…, and performance is mostly defined by available memory and the I/O subsystem. Also, it seems MySQL 5.1 with the InnoDB-plugin, MySQL 5.5, and Percona Server show about the same performance in this case, and it…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
… of top functions and find bug reports or blog posts about this topic. It lead me to … which were responsible for poor performance of SHOW STATUS and crash recovery performance over last couple of years … online in Innodb Plugin, MySQL 5.5 and Percona Server). Yes. if you’re not using innodb_file_per_…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE or CREATE INDEX. Peter has already blogged… to copy the entire table. To illustrate this, I have performed a number of simple benchmarks. Let’s start with a… in the buffer pool, fast index creation provides even better performance as compared to the default method, because it does not…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… blog readers ! Now back to HardCore MySQL business – foreign Keys. MySQL supported Foreign Keys for Innodb … tables as well as making foreign keys performed row by row which often can be very…even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_thread_classes_lostblogpercona.commanual Performance_schema_thread_instances_lostblogpercona.commanual pid_fileblogpercona.commanual pluginblogpercona.commanual plugin_dirblogpercona.commanual plugin…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… what Flickr had to say on their blog. The main improvements come in both performance gains and improvements to diagnostics (such… interesting patches are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB-plugin, the RC status of plugin does not allow…
Comment: 5.4 in-memory tpcc-like load
May 1, 2009 By 11 Comments
…. This is a great way to improve performance for all MySQL users, and to get … suitable license As Vasil described in this blog post (http://blogs.innodb.com/wp/2009/03/software-is-hard…the latest version of the InnoDB Plugin, and conduct our own testing, to ensure InnoDB‘s continued reliability. …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… for you to get your own blog). I should have replied much …functionality ourside of storage engines as plugins. Two aspects why I’m …should happen for most common cases. Innodb scaling issues are the most common…it is asynchronous. To offer great performance on distributed systems, especially if they…
