2015-09-18

MySQL binlog查看和清理

Views: 11084 | Add Comments

显示 binlog 文件列表

show binary logs;

清理 binlog 文件

purge binary logs to 'mysql-bin.000001';

查看 binlog 内容

show binlog events in 'mysql-bin.000001' limit 1000, 10;

或者SHELL命令行

sudo mysqlbinlog mysql-bin.000001

Related posts:

  1. MySQL 数据库双主配置
  2. MySQL 在线增加从库
  3. Linux下编译安装Apache/Nginx/Lighttpd+PHP+MySQL
  4. MySQL”海量数据”查询性能分析
  5. MySQL 基本配置
Posted by ideawu at 2015-09-18 17:08:42 Tags:

Leave a Comment