… 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: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL… are sized appropriately, which shows that the IO access pattern has been changed to become … possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, …
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…
Page: About This Blog
May 3, 2006 By 48 Comments
… on number features for MySQL Performance monitoring and tuning – SHOW MUTEX STATUS, Tuning Innodb mutexes and concurrency control, MMAP IO for MyISAM tables… our company team page. We have published biographies of other MySQL Performance Blog contributers at Percona Team Page
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog…
Comment: Evaluating IO subsystem performance for MySQL Needs
March 6, 2008 By 23 Comments
…Evaluating IO subsystem performance for MySQL Needs | MySQL Performance Blog ‘m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so… quite a lot of what yo (tags: benchmark database disk mysql performance storage sysadmin io) [...]
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…at that now. This topic deserves an entire blog post, because there are many subtleties including …in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance,…intervals and compare the results to your IO system’s capabilities. MySQL doesn’t have good instrumentation …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’… innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery-…verify the numbers in my next blog post. I will compare performance of various cluster sizes on …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL Performance. To start with basics SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance…these variables is indication of IO bound workload. Note however – IO requests submited by threads …rows is much cheaper than accessing 10MB blog, but it is still much more …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…, mailing lists or blogs you probably heard complains about MySQL being unable to handle … LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What …In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO …
