[client] socket=/srv/mysql/mysql.sock [mysql] socket=/srv/mysql/mysql.sock [mysqld] datadir=/srv/mysql log_slow_queries long_query_time=2 max_connections=5000 #max_connect_errors=10 wait_timeout=600 interactive_timeout=600 connect_timeout=10 log-bin=sql-bin log-bin-index=sql-bin.index relay-log=kitchen-sink-relay-bin relay-log-index=kitchen-sink-relay-bin.index skip-locking #skip-external-locking query_cache_limit=1M query_cache_size=128M query_cache_type=1 thread_cache_size=8 table_cache=1024 key_buffer=400M join_buffer=1M record_buffer=1M max_allowed_packet=16M sort_buffer_size=2M read_buffer_size=2M read_rnd_buffer_size=8M tmp_table_size=35M thread_concurrency=4 myisam_sort_buffer_size=8M innodb_buffer_pool_size=512M innodb_additional_mem_pool_size=20M innodb_log_file_size=200M innodb_log_buffer_size=2M #innodb_lock_wait_timeout=50 innodb_file_per_table old_passwords=1 server-id=1 skip-bdb #skip-networking [mysqldump] quick quote-names max_allowed_packet = 16M