… buffer size used by MRR can be controlled by the variable read_rnd_buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the join_buffer_size increased to 6M, the query time was ~300s while when both the join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size were set… 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size=6M MariaDB 5.5…
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: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
Looking for documentation for read_rnd_buffer_size you would find descriptions such as “The read_rnd_buffer_size is used after a sort, when reading rows in sorted…, when performs reading into read_rnd_buffer in the sorted order – it can be pretty much sequential if you’re lucky. The read_rnd_buffer_size is important…
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
… quite unexpected improvements. sort_buffer_size – recently I worked with case which was running much faster with 32K sort_buffer_size, compared to 32M… and some 10 distinct c values. read_buffer_size and read_rnd_buffer_size – These are buffers used by MyISAM to perform reads, in different scenarios. So should we…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Handler_read_firstblogpercona.commanual Handler_read_keyblogpercona.commanual Handler_read_lastblogpercona.commanual Handler_read_nextblogpercona.commanual Handler_read_prevblogpercona.commanual Handler_read_rndblogpercona.commanual Handler_read_rnd_nextblogpercona… rand_seed2blogpercona.commanual range_alloc_block_sizeblogpercona.commanual read_buffer_sizeblogpercona.commanual read_onlyblogpercona.commanual read_rnd_buffer_sizeblogpercona.commanual relay_logblogpercona.commanual relay_log_indexblogpercona…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…_buffer_size – Buffer used for Key preloading, which works for MYISAM tables only. read_buffer_size, read_rnd_buffer_size – Variables used as read buffer for MyISAM tables for Full Table Scan (read_buffer) and for reading rows in sorted order (read_rnd_buffer_size). Other storage…
Comment: MySQL: what read_buffer_size value is optimal ?
September 21, 2008 By 25 Comments
… buffers to 128 kbyte? I put this in my my.cnf: key_buffer_size = 256M sort_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K join_buffer_size = 128K myisam_sort_buffer_size… to the my.cnf): key_buffer_size 268435456 sort_buffer_size 131064 read_buffer_size 126976 read_rnd_buffer_size 126976 join_buffer_size 126976 myisam_sort_buffer_size 131072 The key_buff shows the…
Comment: What exactly is read_rnd_buffer_size
April 1, 2009 By 4 Comments
[...] å¦å¤–ï¼Œå¢žåŠ read_rnd_buffer_size(3.2.3是record_rnd_buffer_size)的值对排åºçš„æ“作也有一点的好处，å‚è§ï¼šhttp://www.mysqlperformanceblog.com/2007/07/24/what-exactly-is-read_rnd_buffer_size/ [...]
Comment: What exactly is read_rnd_buffer_size
March 25, 2009 By 4 Comments
[...] å¦å¤–ï¼Œå¢žåŠ read_rnd_buffer_size(3.2.3是record_rnd_buffer_size)的值对排åºçš„æ“作也有一点的好处，å‚è§ï¼šhttp://www.mysqlperformanceblog.com/2007/07/24/what-exactly-is-read_rnd_buffer_size/ [...]
