June 19, 2013

Post: Virident vCache vs. FlashCache: Part 2

… points and combine that with the fact that the best vCache performance results were obtained with the default vCache …_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

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…during mounting but not during mkfs. This is your best option if you have a proper alignment in partition…

Post: How Percona does a MySQL Performance Audit

bestfile_size. I won’t give you a full rundown over every option in the fileMyISAMsorts