[mysqld] #old_passwords log-slow-queries = /tmp/mysql_slow.log long_query_time = 1 back_log = 50 # This undocumented command seems to drop any compatibility with innodb tables # skip-innodb max_connections = 650 key_buffer_size = 64M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 2500 thread_cache_size = 384 wait_timeout = 35 connect_timeout = 10 tmp_table_size = 128M max_heap_table_size = 128M max_allowed_packet = 64M max_connect_errors = 10 thread_concurrency = 4 concurrent_insert = 2 table_lock_wait_timeout = 35 read_rnd_buffer_size = 524288 bulk_insert_buffer_size = 8M query_cache_limit = 6M query_cache_size = 96M query_cache_type = 1 query_prealloc_size = 131072 query_alloc_block_size = 65536 default-storage-engine = MyISAM [mysqld_safe] nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M