… it will interesting how both InnoDB and…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_repair_threads = 1 myisam…settings out-of-box, but I am ready to…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…size=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_size…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…max_heap_table_size to restrict size of each table total size…file system. MyISAM Sort Buffer – This one is typically set…size. Another possibility is to use queries which use large temporary tables or sort files…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to…to miss, as is the absence of innodb_log_file_size…to convert MyISAM tables to…sorts of interesting things. Basically, anything but silence in the error log is interesting and needs to…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…size bytes of memory if done to MyISAM tables. myisam_sort_buffer_size…how memory consumption reacts to changing various variables. For example you may find out increasing sort_buffer_size from 1MB to 4MB and 1000 max…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to…0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘…files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size…
