[mysqld] skip-name-resolve log-slow-queries=/var/log/slow.log long_query_time=1 max_connections=2000 key_buffer = 256M join_buffer_size = 8M read_buffer_size = 32M sort_buffer_size = 8M interactive_timeout=90 connect_timeout =90 wait_timeout = 90 table_cache = 512 thread_cache=60 thread_cache_size = 32 thread_concurrency=2 tmp_table_size = 64M max_heap_table_size = 64M bulk_insert_buffer_size = 2M max_allowed_packet = 2M max_connect_errors = 1000000 query_cache_limit=4048567 query_cache_size=50m query_cache_type = 1 query_prealloc_size = 16384 query_alloc_block_size = 8192 query_cache_min_res_unit = 4096 [mysqld_safe] open_files_limit = 8192 [mysqlhotcopy] interactive-timeout [mysqldump] quick max_allowed_packet=16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M