mysql> show master logs;
+------------------+------------+
| Log_name | File_size |
+------------------+------------+
| mysql-bin.000023 | 1074039776 |
| mysql-bin.000024 | 1023334365 |
| mysql-bin.000025 | 1073742100 |
| mysql-bin.000026 | 4254255 |
| mysql-bin.000027 | 117 |
| mysql-bin.000028 | 98 |
+------------------+------------+
6 rows in set (0.00 sec)
mysql> purge master logs to 'mysql-bin.000028';
Query OK, 0 rows affected (10.35 sec)
mysql> show master logs;
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000028 | 98 |
+------------------+-----------+
1 row in set (0.00 sec)
mysql>
