mysqlbinlog

binlog-format={ROW|STATEMENT|MIXED}

从statement到row，binlog记录内容改变了很多，但有些问题需要查看binlog才能定位

1.statement

SHOW BINLOG EVENTS in 'mysql-bin.000001' from 4 limit 10;

但是在row模式下无法通过上述语句查看binlog内容

2.row

mysqlbinlog --no-defaults   -v -v  mysql-bin.000001 | grep 11:11 | grep -C 20

• --no-defaults

mysqlbinlog读取my.cnf配置文件参数[client]，报错 mysqlbinlog: unknown variable 'default-character-set=utf8'，也可以将my.cnf中default-character-set = utf8注释掉

•   -v, --verbose      

 Reconstruct SQL statements out of row events. -v -v adds comments on column data types.

• grep可用参数

  -B, --before-context=NUM  print NUM lines of leading context

  -A, --after-context=NUM   print NUM lines of trailing context

  -C, --context=NUM         print NUM lines of output context

  -m, --max-count=NUM       stop after NUM matches