mysqlbinlog --start-position 639576 --stop-position=639745 --base64-output=decode-rows -v mysql-bin.000011
需要从639576 到639745 才能正确解析出语句,不能从639653 到639745
# at 639576 --开始字节偏移量
#170603 9:38:01 server id 114 end_log_pos 639653 CRC32 0x654eef2b Table_map: `user`.`user_records` mapped to number 180
# at 639653 --终止字节偏移量
#170603 9:38:01 server id 114 end_log_pos 639745 CRC32 0xf7a2381b Write_rows: table id 180 flags: STMT_END_F
### INSERT INTO `jdd_user`.`user_records`
### SET
### @1=41795812
### @2=11541077
### @3=1
### @4='2017-06-03 09:38:01'
### @5=22
### @6=6
### @7='xxx'
# at 639745 --终止字节偏移量
阅读(1186) | 评论(0) | 转发(0) |