数据库优化


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip_name_resolve = ON
symbolic-links= 0

# 启用记录慢查询日志
log_slow_queries = ON

# 是否启用慢查询
slow_query_log = ON

# 二进制日志文件
log_bin = /backup-xuekaixin/data_MySQL/binlog/binlog.file
max_binlog_size = 524288000

# 缓存
query_cache_min_res_unit = 4096
query_cache_type = ON
query_cache_size = 10240000
query_cache_limit=1048576

# 最大连接数
max_connections = 200