mysql binlog日志清理(purge binary logs)

 

 

mysql> show variables like '%expire_logs_days%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| expire_logs_days | 3 |
+------------------+-------+
1 row in set (0.00 sec)

 

-- 删除指定日志文件(该文件不会删除)之前的所有日志文件
PURGE BINARY LOGS TO 'binlog.001718';

 

-- 删除指定日期之前的所有日志文件
PURGE BINARY LOGS BEFORE '2025-02-14 00:00:00';