mysql 清重所有日志重新同步_MySQL主从同步日志清理

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

自动清除配置

vim /etc/my.cnf

#二进制日志自动删除的天数。默认值为0,表示“没有自动删除” #一般将x设置为短点，如10

expire_logs_days = x

#此方法需要重启mysql，附录有关于expire_logs_days的英文说明

当然也可以不重启mysql,开启mysql主从，直接在mysql里设置expire_logs_days

> show binary logs;

> show variables like '%log%';

> set global expire_logs_days = 10;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

手动删除

> PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 10 DAY); //删除10天前的MySQL binlog日志,附录2有关于PURGE MASTER LOGS手动删除用法及示例

> show master logs;

扩展

1.expire_logs_days英文说明

Where X is the number of days you’d

like to keep them around.

I would recommend 10, but this depends on how

busy your MySQL server is and how fast these log files grow.

Just make

sure it is longer than the slowest slave takes to replicate the data

from your master.

Just a side note: You know that you should do this

anyway, but make sure you back up your mysql database.

The binary log

can be used to recover the database in certain situations;

so having a

backup ensures that if your database server does crash, you will be able

to recover the data.

2.PURGE MASTER LOGS手动删除用法及示例,MASTER和BINARY是同义词

> PURGE {MASTER | BINARY} LOGS TO 'log_name'

> PURGE {MASTER | BINARY} LOGS BEFORE 'date'

删除指定的日志或日期之前的日志索引中的所有二进制日志。这些日志也会从记录在日志索引文件中的清单中被删除MySQL BIN-LOG 日志，这样被给定的日志成为第一个。

实例：

> PURGE MASTER LOGS TO 'MySQL-bin.010'; //清除MySQL-bin.010日志

> PURGE MASTER LOGS BEFORE '2008-06-22 13:00:00'; //清除2008-06-22 13:00:00前binlog日志

> PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY); //清除3天前binlog日志BEFORE，变量的date自变量可以为'YYYY-MM-DD hh:mm:ss'格式。

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------