[mysqld] local-infile=0 skip-networking skip-name-resolve query_cache_type=1 query_cache_limit=4M query_cache_size=400M max_connections=100 wait_timeout=150 table_cache=400M tmp_table_size=128M max_heap_table_size=256M thread_cache=200M sort_buffer_size=512K read_buffer_size=512K read_rnd_buffer_size=3M myisam_sort_buffer_size=200M max_allowed_packet=5M [mysqldump] quick max_allowed_packet=8M [mysql] #no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer=128M sort_buffer=128M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=128M sort_buffer=128M read_buffer=16M write_buffer=16M