只需要两句话:
# 此命令显示当前使用的二进制日志,或者说日志数目
mysql> SHOW MASTER LOGS;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| binlog.000006 | 45342282 | | |
+---------------+----------+--------------+------------------+
然后:
mysql> PURGE MASTER LOGS TO 'binlog.000006';