…_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=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… 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 = 10G myisam_repair_threads = 1 myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… 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_repair_threads = 1 myisam…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… is a per session buffer that is allocated every time it is needed. The problem with the sort buffer comes from the way… sort_buffer. It is my understanding that the sort_buffer is used when no index are available to help the sorting so I created a MyISAM… the number of sort merge passes. For the small values of the sort buffer size, below 440KB, there are many sort merge passes and…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be done by key_cache rather than sort which can… have many tables which are being repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table… watch out. Lack of row cache. MyISAM tables only have indexes cached in key_buffer while data is cached in OS cache…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual myisam_max_sort_file_sizeblogpercona.commanual myisam_mmap_sizeblogpercona.commanual myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only. But… of pointers from sort_buffer (just enough so all rows fit in read_rnd_buffer as they are read) and sorts them by row…_length_for_sort_data) data should be stored in sort buffer and sort file so there would be no need for read_rnd_buffer, if…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… as full table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size… – bulk inserts may allocate bulk_insert_buffer_size bytes of memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…=8 #*** MyISAM Specific options myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=185M key_buffer_size=157M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer…
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
… provide quite unexpected improvements. sort_buffer_size – recently I worked with case which was running much faster with 32K sort_buffer_size, compared to… some 10 distinct c values. read_buffer_size and read_rnd_buffer_size – These are buffers used by MyISAM to perform reads, in different…
