作为一个oracle dba有时候不得不管理一下mysql数据库，当为主从库时需要阶段性清理mysql binary log，清楚方式如下：
首先查看mysql 的当前日志组
show master status;
确定当前日志组后删除日志文件
purge binary logs to ‘mysql-bin.000795‘;
删除000795之前的日志
相关文章
- 07-12c# – 每次在进程中调用XmlConfigurator.Configure()时,log4net如何不清除日志
- 07-12Got fatal error 1236 from master when reading data from binary log: 'Could not find first log f
- 07-12【MySQL案例】error.log的Warning：If a crash happens thisconfiguration does not guarantee that the relay lo
- 07-12Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'系列一：
- 07-12（转）主从同步遇到 Got fatal error 1236 from master when reading data from binary log: 'Could not find f
- 07-12Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position
- 07-12定时清除 /var/log/massage 下的信息脚本文件
- 07-12二进制日志(binary log)
- 07-12(转)主从同步遇到 Got fatal error 1236 from master when reading data from binary log: 'Could not find f
- 07-12The General Query Log Binary Log