… are a little slow to blog about this and acknowledge the… member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition…MySQL 5.5 offers pluggable authentication; you just have to pay for the plugin… partitioning, and the addition of multiple InnoDB buffer pools. Best of all,…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
…all blog readers ! Now back to HardCore MySQL business – foreign Keys. MySQL supported Foreign Keys for Innodb for…tables as well as making foreign keys performed row by row which often can be …even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping…
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…-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such…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
… performance (as you may see from Dimitri’s post, http://dimitrik.free.fr/blog/archives/2010/12/mysql-performance-analyzing-perconas-tpcclike-workload-on-mysql…. 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…
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: 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… have performed a number of simple benchmarks. Let’s start with a table containing 4 million rows and one secondary key: mysql… ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the previous one: mysql> SET expand_fast_index…
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 …which were responsible for poor performance of SHOW STATUS and crash recovery performance over last couple of …variable online in Innodb Plugin, MySQL 5.5 and Percona Server). Yes. if you’re not using innodb_file_per…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… for you to get your own blog). I should have replied much … plugins instead of patches. 2. Be Scalable I’d like to see MySQL…should happen for most common cases. Innodb scaling issues are the most common…single MySQL server with improved performance and high availability. Of course there is MySQL …
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… to say on their blog. The main improvements come in both performance gains and improvements to…are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB-plugin, the RC status of plugin … for tpce-like benchmark, where I compare MySQL-5.1.43 vs percona-5.1.43…
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 the maximum … suitable license As Vasil described in this blog post (http://blogs.innodb.com/wp/2009/03/software-is-… latest version of the InnoDB Plugin, and conduct our own testing, to ensure InnoDB‘s continued reliability. …
