查看二进制日志文件mysql> SHOW BINLOG EVENTS \G;mysql> SHOW MASTER LOGS;清除二进制日志文件mysql> PURGE { MASTER|BINARY } LOGS TO ‘log_name‘;mysql> PURGE { MASTER|BINARY } LOGS BEFORE ‘datetime‘;例如： mysql> PURGE MASTER LOGS TO ‘mysql-bin.000001‘; mysql> PURGE MASTER LOGS BEFORE ‘2009-12-20 13:00:00‘;另一种清除二进制日志方法mysql > flush logs;mysql > reset master;