[mysqld]
#key_buffer_size+(read_buffer_size+sort_buffer_size)*max_connections
#=384M+(2M+2M)*100=784M
port = 3306
skip-external-locking #跳过外部锁定
key_buffer_size = 384M #256M(内存1G) 400M(内存2G)
max_allowed_packet = 2M #2M(内存1G) 4M(内存2G)
table_open_cache = 64 #small=4,medium=64,large=256,huge=512
sort_buffer_size = 2M #2M(内存1G) 4M(内存2G) 8M(内存4G)
net_buffer_length = 512K
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M #64M(内存1G) 128M(内存2G)
thread_cache_size = 8 #8(内存1G) 64(内存2G)
query_cache_size = 32M #32M(内存1G) 64M(内存2G)
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
max_connections = 100 #允许的并行客户端连接数目。
wait_timeout = 60 #等待超时时间
connect_timeout = 3 #连接超时
interactive_timeout = 120 #活动连接超时
long_query_time = 1 #长查询时间
log-slow-queries = mysqlslowquery.log #记录慢查询
log_bin_trust_function_creators=1
log-bin=mysql-bin
binlog_format=mixed
server-id = 20660
replicate-rewrite-db="96dt_radio->96dt_radio"
replicate-do-db=96dt_radio