mysql查看binlog文件列表

1
SHOW BINARY LOGS;

清理binlog

1
PURGE BINARY LOGS BEFORE NOW();

设置日志时间

1
2
SHOW VARIABLES LIKE 'expire_logs_days';
SET GLOBAL expire_logs_days = 7;