设置mysql定期删除 binlog my.cnf expire_logs_days = 1 # 0为不删除
重启生效
show binary logs; show variables like '%log%'; set global expire_logs_days = 7;
手动删除
PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY); show binary logs;
设置mysql定期删除 binlog my.cnf expire_logs_days = 1 # 0为不删除
重启生效
show binary logs; show variables like '%log%'; set global expire_logs_days = 7;
手动删除
PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY); show binary logs;
转载于:https://my.oschina.net/jingdor/blog/501597