…_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_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: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…_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: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options 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 #myisam_max_extra_sort_file_size…
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: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… 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: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…BUFFER_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…
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…
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/ [...]
