…was sysbench 0.5 and… appears to get *better* over …set size in relation to both the working set and the cache device size…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: 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…settings in the file system. This is what you would often get…
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: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…MAX_TABLE_HANDLES | 100000 | 2223 | | INNODB_LOG_FILE_SIZE | 5242880 | 50331648 | | BASEDIR | /mnt/nfs/dist/5.5.30 | /mnt/nfs/dist/5…getting MyISAM because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL 5…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…file system. MyISAM Sort Buffer – This one is typically set…max_prepared_stmt_count very low. Prepared Statements and Blob Data If you’re want to get…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
…file_size. I won’t give you a full rundown over every option in the file…MyISAM…sorts…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…file FullText search related variables. As FullText currently works with MyISAM tables these are MyISAM related. join_buffer_size…sorted order (read_rnd_buffer_size). Other storage engines such as Innodb to not use this variable. sort_buffer_size Buffer used to sort result set…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…sort_buffer_size=24M read_buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set… was: why would this table get so fragmented or come to…, is as good as a file system on steroids and nothing … was a pathetic “option”. Yes 5.x has included triggers, stored …
