清除master logs
把多余的日志删除了。只保留当前一个日志文件。
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 99 to server version: 5.0.24 -community-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show master logs;
+------------------+------------+
| Log_name | File_size |
+------------------+------------+
| mysql-bin.000026 | 1073742051 |
| mysql-bin.000027 | 675531614 |
+------------------+------------+
2 rows in set (0.03 sec)
mysql> purge master logs to 'mysql-bin.000027';
Query OK, 0 rows affected (0.31 sec) <------------- 这里 ---------
mysql> show master logs;
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000027 | 675627704 |
+------------------+-----------+
1 row in set (0.00 sec)
mysql>