June 18, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

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 = 10G myisam

Post: MySQL Server Memory Usage

buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQLread_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size