mysql binlog日志清理

先看好要清理几月份的

然后清理
purge master logs before'2020-09-30 17:20:00';

然后确定下是否需要设置过期时间策略

可以借鉴这个博客
https://www.cnblogs.com/samsui/p/12035496.html

sep是9月其他英文月份缩写一月份＝JAN. Jan.=January二月份＝FEB. Feb.=February三月份＝MAR. Mar.=March四月份＝APR. Apr.=April五月份＝MAY May=May六月份＝JUN. Jun.=June七月份＝JUL. Jul.=July八月份＝AUG. Aug.=August九月份＝SEP. Sept.=September十月份＝OCT. Oct.=October十一月份＝NOV. Nov.=November十二月份＝DEC. Dec.=December如果有帮助请参考

如果是 mysql-bin.002799 这种类型的
show binary logs;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 12610
Current database: *** NONE ***

+------------------+------------+
| Log_name | File_size |
+------------------+------------+
| mysql-bin.002799 | 1521772771 |
| mysql-bin.002800 | 1075864938 |
| mysql-bin.002801 | 1074353461 |
| mysql-bin.002802 | 1080212340 |
| mysql-bin.002803 | 1077382274 |
| mysql-bin.002804 | 1075679594 |
| mysql-bin.002805 | 1075257872 |
| mysql-bin.002806 | 1073815925 |

清理30天前的日志

PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY);