[MySQL binlog]mysql如何彻底解析Mixed日志格式的binlog

mysql binlog3种格式,row,mixed,statement. 解析工作 mysqlbinlog –base64-output=DECODE-ROWS -v mysql-bin.000144 |more –base64-output=DECODE-ROWS: 会显示出row模式带来的sql变更。 -v :显示statement模式带来的sql语句 代码如下:[mysql@002tmp]$ mysqlbinlog –base64-output=DECODE-ROWS -v mysql-bin.000144 |more/*!40019 SET @@session.max_in