Mysql-binlog清理

Mysql-binlog清理

mysql5.x

vi /etc/my.cnf
expire_logs_days = 7

mysql> set global expire_logs_days = 7;
mysql> flush logs;

mysql8

##查看数
mysql> show variables like 'binlog_expire%';
+----------------------------+---------+
| Variable_name | Value |
+----------------------------+---------+
| binlog_expire_logs_seconds | 2592000 |
+----------------------------+---------+
1 row in set (0.00 sec)

mysql> show binary logs;

## 设置有效期，清理5天前的binlog的配置
mysql> set global binlog_expire_logs_seconds = 432000;
mysql> flush logs;

## 配置文件
binlog_expire_logs_seconds = 432000