mysqlbinlog

0x01.

至少取出一个transaction才行, position的数字为binlog中# at xxxxxx
mysqlbinlog -vv mysql-bin.000684 --start-datetime='2017-02-14 07:38:01' --stop-datetime='2017-02-14 07:39:01' --database=xxx
mysqlbinlog -vv mysql-bin.000684 --start-position='574644402' --stop-position='574644667' --database=xxx
前后要保证BEGIN和COMMIT格式