快速清理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'

http://coolnull.com/154.html