mysql 自带的 binlog 解析工具

通过 sql

show binlog events in ‘mysql_bin.000002’;

• show binlog events in ‘binlog.000001’ limit 10;

• show binlog events in ‘binlog.000001’ limit 10, 10; // 这个是从第 10 个 event 开始

• show binlog events in ‘binlog.000001’ from 101111 limit 10; // 这个是从位点 101111 开始

通过 mysqlbinlog

• mysqlbinlog 常用命令
  http://www.ttlsa.com/mysql/super-useful-mysqlbinlog-command/

• 在 mysql 安装目录的 bin 文件夹
  /home/shicai.xsc/mysql/bin/mysqlbinlog

• 解析成 sql 语句
  /home/shicai.xsc/mysql/bin/mysqlbinlog --base64-output=“decode-rows” -v /home/shicai.xsc/mysql/data/mysql1/mysql_bin.000002