MySQL需要定期清理binary log文件,否则占用大量磁盘空间。
CMD:
mysql -u XXXX -p
mysql> show binary logs;
±---------------------------±-----------±----------+
| Log_name | File_size | Encrypted |
±---------------------------±-----------±----------+
| LAPTOP-JEHA1ED9-bin.000001 | 178 | No |
| LAPTOP-JEHA1ED9-bin.000002 | 38600442 | No |
| LAPTOP-JEHA1ED9-bin.000003 | 1549588 | No |
| LAPTOP-JEHA1ED9-bin.000004 | 155 | No |
28 rows in set (0.03 sec)
mysql> show master status;
±---------------------------±----------±-------------±-----------------±------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
±---------------------------±----------±-------------±-----------------±------------------+
| LAPTOP-JEHA1ED9-bin.000028 | 689639589 | | | |
±---------------------------±----------±-------------±-----------------±------------------+
1 row in set (0.00 sec)
mysql> purge binary logs to ‘LAPTOP-JEHA1ED9-bin.000028’;
Query OK, 0 rows affected (0.13 sec)