…_POOL_READ_AHEAD_RND | 0 | | INNODB_BUFFER_POOL_READ_AHEAD | 38392 | | INNODB_BUFFER_POOL_READ_AHEAD_EVICTED | 0 | | INNODB_BUFFER_POOL_READ_REQUESTS | 6731100 | | INNODB_BUFFER_POOL_READS | 570…_POOL_READ_AHEAD_RND | 0 | | INNODB_BUFFER_POOL_READ_AHEAD | 38461 | | INNODB_BUFFER_POOL_READ_AHEAD_EVICTED | 0 | | INNODB_BUFFER_POOL_READ_REQUESTS | 6731687 | | INNODB_BUFFER_POOL_READS | 550…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… 507516 Handler_read_next 574320 574320 572889 574320 572889 Handler_read_rnd_next 136077 136094 136366 136163 136435 Innodb_buffer_pool_read_ahead 0 20920 23669 20920 23734 Innodb_buffer_pool_read_requests…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… Handler_read_next 2651500 2628103 2586036 2628103 2592816 2615612 Handler_read_rnd_next 23078 22780 22757 22867 23049 23221 Innodb_buffer_pool_read_ahead 1152 23231 130919 23228 130731 131497 Innodb_buffer_pool_read…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…read_aheadblogpercona.commanual Innodb_buffer_pool_read_ahead_evictedblogpercona.commanual Innodb_buffer_pool_read…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb… plan optimizer-prune-level=0 partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name…=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
…. read_buffer_size and read_rnd_buffer_size – These are buffers used by MyISAM to perform reads, in different scenarios. So should we go ahead… allocate the buffer and populate if fully when MySQL will read only 5 rows from the buffer and throw away the…
