Mysql—配置文件my.ini或my.cnf的详解

[mysqld]
log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 7  # 超过7天的binlog删除

slow_query_log = 1
long_query_time = 3                       # 慢查询时间 超过3秒则为慢查询
slow-query-log-file = /www/server/data/mysql-slow.log

log_error = /data/mysql/mysql-error.log   # 错误日志路径