手动清除
不要删除当前正在使用的binlog
查看binlog列表:
msyql> show master logs;
mysql> show binary logs;
查看当前正在使用的binlog:
mysql> show master status
删除指定文件或日期(不包括)之前的binlog:
PURGE MASTER LOGS TO 'mysql-bin.xxx';
PURGE MASTER LOGS BEFORE '2015-05-02 22:46:26';
Syntax:
PURGE {MASTER | BINARY} LOGS TO 'log_name'
PURGE {MASTER | BINARY} LOGS BEFORE 'date'
Master和Binary含义相同
定期自动清除
1. 修改配置my.cnf
expire_logs_days = 30
2. 运行时,通过mysql命令行修改:
show binary logs;
show variables like '%log%';
set global expire_logs_days = 30;