binglog清理

目录

• 查看binlog
• 自动删除
• 手动删除

 

---

回到顶部

查看binlog

MySQL [(none)]> show binary logs;

+------------------+------------+
| Log_name         | File_size  |
+------------------+------------+
| mysql-bin.000246 | 1073742039 |
| mysql-bin.000247 | 1073742006 |
| mysql-bin.000248 |  161823524 |
+------------------+------------+
3 rows in set (0.00 sec)

回到顶部

自动删除

MySQL [(none)]> set global expire_logs_days=1;

Query OK, 0 rows affected (0.00 sec)

回到顶部

手动删除

MySQL [(none)]> purge binary  logs to 'mysql-bin.000246';

or

MySQL [(none)]> purge master logs to 'mysql-bin.000246';

Query OK, 0 rows affected (4.53 sec)