开启Binary log(二进制日志)记录Mysql更新内容，在服务重启或者超出binlog大小上限的情况下mysqld会创建新的binlog，时间长了本地会保留很多binlog，我们应将历史binlog清除

1.刷新日志

mysql > flush logs;

2.查看当然数据库binlog信息

mysql > show binary logs;

+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000023 | 149 |
| mysql-bin.000024 | 149 |
| mysql-bin.000025 | 149 |
| mysql-bin.000026 | 149 |
| mysql-bin.000027 | 149 |
| mysql-bin.000028 | 106 |
+------------------+-----------+

3.清除历史log，保留最近的

mysql > purge binary logs to 'mysql-bin.000028';

4.查看binlog事件

mysql > show binlog events;

+------------------+-----+-------------+-----------+-------------+---------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+------------------+-----+-------------+-----------+-------------+---------------------------------------+
| mysql-bin.000023 | 4 | Format_desc | 1 | 106 | Server ver: 5.1.31-log, Binlog ver: 4 |
| mysql-bin.000023 | 106 | Rotate | 1 | 149 | mysql-bin.000024;pos=4 |
+------------------+-----+-------------+-----------+-------------+---------------------------------------+

5.查看本地binlog文件

# ls -l /data/dbfile

mysql-bin.000028
mysql-bin.index

查看当前使用的Binary log名称

# more mysql-bin.index
./mysql-bin.000023
./mysql-bin.000024
./mysql-bin.000025
./mysql-bin.000026
./mysql-bin.000027
./mysql-bin.000028

备份中清除日志

# mysqldump --flush-logs --delete-master-logs