MySQL中3种清除binlog的方法!

-- mysql delete log online 

1  mysql命令purge

mysql> purge master logs to "mysql-bin.000410";
Query OK, 0 rows affected (3.71 sec)

 

2 手动rm清理  

rm -rf mysql-bin.00040*;
vim mysql-bin.log.index
清除掉里面的mysql-bin.0004**纪录

 

3 参数清理

set global expire_logs_days=5;

系统自动清理