-- =============== 配置 ================
-- 开启慢日志查询(my.ini/my.cf v5.7)
[mysqld]
slow_query_log = ON
#目录必须存在,否则启动后查看的slow_query_log状态为OFF
slow_query_log_file= $MYSQL_HOME/logs/mysql-slow.log
long_query_time= 2
#谨慎开启使用
log_queries_not_using_indexes = OFF
-- 开启错误日志
log_error = $MYSQL_HOME/logs/mysql-log.err
-- 查看bin-log是否开启
SHOW VARIABLES LIKE '%log_bin%';
-- 开启bin-log
[mysqld]
#server_id不能重复
server_id = 1
#log_bin[=base_name]
log_bin = $MYSQL_HOME/mysql-bin
-- =============== 设置 ================