快速清理binlog
PURGE MASTER LOGS BEFORE '2008-06-22 13:00:00'; //清除2008-06-22 13:00:00前binlog日志
PURGE MASTER LOGS TO 'MySQL-bin.010'; //清除MySQL-bin.010和之前的日志
my.ini 配置二进制日志自动删除的天数。默认值为0,表示“没有自动删除”
expire_logs_days = x
实时清理SQL
PURGE {MASTER | BINARY} LOGS TO 'log_name'
PURGE {MASTER | BINARY} LOGS BEFORE 'date'