修改MySQL的bin-log日志过期时间要在主库上来做。如果mysql只有一个单节点,同样适用
查看当前过期时间
mysql> show variables like '%logs_days%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| expire_logs_days | 90 |
+------------------+-------+
1 row in set (0.00 sec)
修改过期时间
mysql> set global expire_logs_days=7;
Query OK, 0 rows affected (0.00 sec)
# 此方法立即生效
查看日志文件大小
mysql> show variables like 'max_binlog_size';
+-----------------+------------+
| Variable_name | Value |
+-----------------+------------+
| max_binlog_size | 1073741824 |
+-----------------+------------+
1 row in set (0.00 sec)
配置文件永久修改
# vim