mysql binlog清算

不知道你有没有为mysql的binlog占用大量磁盘感到无奈，my.cnf里binlog的size可以设置多大做分割，但没有看到删除的配置，在mysql里show了一下variables，

mysql> show variables like ‘expire_logs_days%’;
+——————+——-+
| Variable_name    | Value |
+——————+——-+
| expire_logs_days | 10    |
+——————+——-+
1 row in set (0.00 sec)

这个默认是0，也就是logs不过期，现在是10天也有点长了，推荐3天
set global expire_logs_days=3;

查看bin log
mysql> show binary logs;
+——————+———–+
| Log_name         | File_size |
+——————+———–+
| mysql-bin.003264 | 104857665 |
| mysql-bin.003265 | 104858206 |
| mysql-bin.003266 | 104857901 |
| mysql-bin.003267 | 104857830 |
| mysql-bin.003268 | 104858231 |
| mysql-bin.003269 | 104857656 |
| mysql-bin.003270 | 104857646 |
| mysql-bin.003271 | 104858180 |
| mysql-bin.003272 | 104857905 |
| mysql-bin.003273 | 104857839 |
| mysql-bin.003274 | 104858611 |

通过purge binary logs to删除,003270之前的会被delete掉
purge binary logs to ‘mysql-bin.003270’;