This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In …_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…k; COMMIT; That is, our PRIMARY KEY is not sequential anymore, which is bad for InnoDB, but this is what I need …buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…entirely sure why that’s the case or at what point the performance is going to level off since these tests …table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G…
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 order… read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only. But talking to Monty today I learned it is…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… let’s take a look at what this optimization actually is and what benefits it brings. Multi Range Read With traditional secondary index lookups… fetched, and N is the buffer size. In MySQL 5.6 the buffer size used by MRR can be controlled by the variable read_rnd_buffer_size, while MariaDB…
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/ [...]
Comment: What exactly is read_rnd_buffer_size
January 16, 2009 By 4 Comments
[...] MySQL Performance Blog: What exactly is read_rnd_buffer_size? [...]
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…optimization that is used in conjunction with BKA and that is MRR Key-ordered Scan. Let’s see what this optimization actually is. …join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size and both of these buffers should be increased appropriately for the best possible performance gain. This is …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…documentation or forums. So I present to you what is now my newest Firefox toolbar bookmark: an …commanual range_alloc_block_sizeblogpercona.commanual read_buffer_sizeblogpercona.commanual read_onlyblogpercona.commanual read_rnd_buffer_sizeblogpercona.commanual relay_logblogpercona.commanual relay…
