[client] #password = your_password port = 3306 socket = /var/tmp/mysql.sock [mysqld] skip-locking key_buffer = 64M max_allowed_packet = 8M table_cache = 512 sort_buffer_size = 1M read_buffer_size = 1M thread_cache_size=128 myisam_sort_buffer_size = 16M thread_cache = 8 thread_concurrency = 8 skip-innodb query_cache_limit = 1M query_cache_size = 8M query_cache_type = 1 set-variable = max_connections=500 set-variable = interactive_timeout=60 set-variable = wait_timeout=60 set-variable = connect_timeout=60 set-variable = max_connect_errors=1 set-variable = join_buffer_size=2M log-bin server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 64M sort_buffer_size = 64M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 64M sort_buffer_size = 64M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout