mysql bin log oversize processing method
Let me help you solve the problem of MySQL binlog files taking up too much space. Here are a few options to deal with it: Clean up old binlog files — 查看当前的 binlog 文件列表 SHOW BINARY LOGS; — 手动删除指定日期之前的 binlog PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 7 DAY); — 或者删除指定文件之前的所有日志 PURGE BINARY LOGS TO ‘mysql-bin.000123’; […]
mysql bin log oversize processing method Read More »