问题背景:
在我们磁盘空间维护策略中,BINLOG的默认保留期限为7天,但当磁盘空间不足时,会根据磁盘空间使用率自动清理超过一定数量的BINLOG。
问题原因:
某服务器上报磁盘空间不足,登录服务器发现BINLOG占用空间过多导致磁盘空间使用率较高,而自动清理BINLOG作业运行正常,但BINLOG没有被及时清理。
手动执行PURGE MASTER LOGS操作,发现执行速度很快,但存在WARNING:
+---------+------+-----------------------------------------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+-----------------------------------------------------------------------------------------------------------------+
| Warning | 1867 | file ./mysql-bin.011530 was not purged because it was being read by 1 thread(s), purged only 0 out of 51 files. |
+---------+------+-----------------------------------------------------------------------------------------------------------------+