… ext4: http://blog.tsunanet.net/2011/09/ext4-2x-faster-than-xfs.html So we built all our MySQL DBs with ext4… developments in the XFS world have greatly enhanced the metadata performance of XFS (especially with regards to metadata fragmentation), so maybe…, or using nobarrier, all have no statistically significant impact on performance, which seems to indicate that XFS had some bottleneck internally…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4… when I need more “power”. Not sure what the MySQLDB performance cracks like Baron recommend you to be on the safe…_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… new High Performance MySQL, 3rd Edition (worth $55 each), the recently released update to the popular second edition! This year’s MySQL Conference… contact the winners privately to confirm, and then post another blog entry here to announce the results. Make sure we (or… prizes are a free copy of the new book “High Performance MySQL, 3rd Edition” which will be available for pickup at the…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… meeting last week, so we are a little slow to blog about this and acknowledge the great work that has gone… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… of MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… mysql. (Ie possibly real MariaDB usage must be higher than what you’d believe from simply reading the blog posts on planet mysql…’t see the problem distros have with the MySQL model. Contrary to common belief MySQL maintenance releases have never included new features… patch security issues whereas MySQL also fixes non-security bugs like server crash, wrong result or just performance regressions. From my point…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… same thing. I often see tweets like “Oracle has killed MySQL and made it closed-source.” Actually, people often say this… reason I make some effort to blog and speak about Oracle’s real contributions to MySQL: I can’t stand when people are wrong on the internet 
Maybe the new High Performance MySQL book will…
Post: MySQL Performance Blog was down today
November 21, 2009 By 3 Comments
MySQL Performance Blog (and percona.com too) were down today because the switch …
