01-11-2012, 03:25 PM
I tried my best to replicate their reading style
Majority of changes made to address IO bound issues and 32bit limitations.
Options have been reorganized to ease readability.
Comments have been added to clarify each section.
wait_timeout and interactive_timeout have been lowered to reduce idle connections impact on max_connections.
core_file has been enabled in order to locate crashed MySQL to address possible innodb failures.
delayed_insert_timeout lowered to reduce memory and cpu overhead from holding data.
delayed_queue_size lowered to reduce memory overhead per table.
query_cache_size increased to 760M to store more query results.
query_cache_limit decreased to 2M to lower prunes and increase the amount of queries that can be stored.
key_buffer_size decreased to 8M as key size requirements across most boxes is quite low and not required to be large.
table_definition_cache increase to 32,768 in order to lower the amount of frm rereads, this might be increased in the future.
table_cache set to 4096 to limit the amount of file holds on requested tables.
open_files_limit set to 16384 to allowed tmp table and table_cache overhead.
myisam_max_sort_file_size set to 256M to prevent a repair/alter table command from filling /var/mysqltmp with files.
thread_cache_size lowered to 64 to limit the amount of threads and to better match our typical thread usage requirements.
sort_buffer_size lowered to 2M to decrease the amount of max memory per thread.
read_buffer_size lowered to 2M to decrease the amount of max memory per thread.
join_buffer lowered to 2M to decrease the amount of max memory per thread.
myisam_sort_buffer_size lowered to 2M to decrease the amount of max memory per thread.
read_rnd_buffer_size lowered to 256k to decrease the amount of max memory per thread.
tmp_table_size lowered to 32MB to massage large queries to disk.
max_heap_table_size lowered to 32MB to push memory tables to disk quicker.
Majority of changes made to address IO bound issues and 32bit limitations.
Options have been reorganized to ease readability.
Comments have been added to clarify each section.
wait_timeout and interactive_timeout have been lowered to reduce idle connections impact on max_connections.
core_file has been enabled in order to locate crashed MySQL to address possible innodb failures.
delayed_insert_timeout lowered to reduce memory and cpu overhead from holding data.
delayed_queue_size lowered to reduce memory overhead per table.
query_cache_size increased to 760M to store more query results.
query_cache_limit decreased to 2M to lower prunes and increase the amount of queries that can be stored.
key_buffer_size decreased to 8M as key size requirements across most boxes is quite low and not required to be large.
table_definition_cache increase to 32,768 in order to lower the amount of frm rereads, this might be increased in the future.
table_cache set to 4096 to limit the amount of file holds on requested tables.
open_files_limit set to 16384 to allowed tmp table and table_cache overhead.
myisam_max_sort_file_size set to 256M to prevent a repair/alter table command from filling /var/mysqltmp with files.
thread_cache_size lowered to 64 to limit the amount of threads and to better match our typical thread usage requirements.
sort_buffer_size lowered to 2M to decrease the amount of max memory per thread.
read_buffer_size lowered to 2M to decrease the amount of max memory per thread.
join_buffer lowered to 2M to decrease the amount of max memory per thread.
myisam_sort_buffer_size lowered to 2M to decrease the amount of max memory per thread.
read_rnd_buffer_size lowered to 256k to decrease the amount of max memory per thread.
tmp_table_size lowered to 32MB to massage large queries to disk.
max_heap_table_size lowered to 32MB to push memory tables to disk quicker.