MySQL配置文件

[client]
socket = /tmp/mysql.sock

[mysqld]
socket = /tmp/mysql.sock

#连接超时(五天)
wait_timeout= 500000
#连接空闲超时
interactive_timeout = 500000

#跳过外部锁定
skip-locking
#解决远程登录慢,实际上为取消DNS的反向解析
skip-name-resolve

#以下为增加大小
query_cache_size=512M

table_cache=4096

tmp_table_size=256M

thread_cache_size=256

myisam_sort_buffer_size=64M

key_buffer_size=128M

read_buffer_size=4M
read_rnd_buffer_size=8M

sort_buffer_size=4M

innodb_additional_mem_pool_size=20M

innodb_flush_log_at_trx_commit=2

innodb_log_buffer_size=10M

innodb_buffer_pool_size=1024M

innodb_log_file_size=38M

innodb_thread_concurrency=8