[mysqld] socket=/var/lib/mysql/mysql.sock safe-show-database #old_passwords back_log = 100 #skip-innodb max_connections = 1200 key_buffer_size = 200M myisam_sort_buffer_size =512K join_buffer_size = 512K read_buffer_size = 512K sort_buffer_size = 512K read_rnd_buffer_size = 512K max_allowed_packet=1M table_cache = 100 thread_cache_size = 128 wait_timeout = 30 connect_timeout = 25 tmp_table_size = 640M max_heap_table_size = 100M net_buffer_length = 160384 max_connect_errors = 100000 thread_concurrency = 8 table_lock_wait_timeout = 30 bulk_insert_buffer_size = 512K query_cache_limit = 200M query_cache_size = 200M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM log-bin=mysql-bin server-id=1 innodb_flush_log_at_trx_commit=1 sync_binlog=1 [mysqld_safe] nice = -20 open_files_limit = 208192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 128M sort_buffer = 64M read_buffer = 16M write_buffer = 16M