[appdeploy@CNSZ22PL0088:/home/appdeploy/dev]$more d.sql
# at 382360604
#170331 0:51:25 server id 1 end_log_pos 382360669 CRC32 0x9378410a Anonymous_GTID last_committed=261487 sequence_number=261488
SET @@SESSION.GTID_NEXT= ‘ANONYMOUS‘/*!*/;
# at 382360669
#170331 0:51:25 server id 1 end_log_pos 382360746 CRC32 0x5b411ddb Query thread_id=315870 exec_time=0 error_code=0
SET TIMESTAMP=1490892685/*!*/;
SET @@session.sql_mode=1436549152/*!*/;
BEGIN
/*!*/;
# at 382360746
#170331 0:51:25 server id 1 end_log_pos 382360827 CRC32 0xa92eacb8 Table_map: `omcssit`.`ts_module` mapped to number 136
# at 382360827
#170331 0:51:25 server id 1 end_log_pos 382361024 CRC32 0x6e6b4b84 Delete_rows: table id 136 flags: STMT_END_F
BINLOG ‘
jTfdWBMBAAAAUQAAAPtcyhYAAIgAAAAAAAMAB29tY3NzaXQACXRzX21vZHVsZQAMCAgPDw8PDwEB
DwEPDmgBLAEsAQgHhAOEA4QDZgq4rC6p
jTfdWCABAAAAxQAAAMBdyhYAAIgAAAAAAAEAAgAM//9A+CQVAwAAAAAAzQAAAAAAAAAYAOeJueau
iuW/q+S7tuebkeaOp+mFjee9rgcAbm92YXRhchsAY3VzdG9tZXJjb25maWd1cmF0aW9uYWN0aW9u
GADnibnmrorlv6vku7bnm5HmjqfphY3nva4DATAAL29tY3MvbmFnYS9jdXN0b21lcmNvbmZpZ3Vy
YXRpb25hY3Rpb24vaW5kZXgucHZ0doRLa24=
--
COMMIT/*!*/;
# at 384675588
#170331 0:53:01 server id 1 end_log_pos 384675653 CRC32 0x9ebd48e9 Anonymous_GTID last_committed=265965 sequence_number=265966
SET @@SESSION.GTID_NEXT= ‘ANONYMOUS‘/*!*/;
# at 384675653
#170331 0:53:01 server id 1 end_log_pos 384675730 CRC32 0x183b0199 Query thread_id=315870 exec_time=0 error_code=0
SET TIMESTAMP=1490892781/*!*/;
BEGIN
/*!*/;
# at 384675730
#170331 0:53:01 server id 1 end_log_pos 384675811 CRC32 0x50a40937 Table_map: `omcssit`.`ts_module` mapped to number 136
# at 384675811
#170331 0:53:01 server id 1 end_log_pos 384676008 CRC32 0x8de7d31f Delete_rows: table id 136 flags: STMT_END_F
BINLOG ‘
7TfdWBMBAAAAUQAAAOOv7RYAAIgAAAAAAAMAB29tY3NzaXQACXRzX21vZHVsZQAMCAgPDw8PDwEB
DwEPDmgBLAEsAQgHhAOEA4QDZgo3CaRQ
7TfdWCABAAAAxQAAAKiw7RYAAIgAAAAAAAEAAgAM//9A+CFQAAAAAAAAzQAAAAAAAAAbAOS4rei9
rOWcuuWPkei/kOmFjee9rua1i+ivlQcAbm92YXRhchUAcHJvZHVjdGNvbmZpZ3VyYXRpb25UGwDk
uK3ovazlnLrlj5Hov5DphY3nva7mtYvor5UDATAAL29tY3MvbmFnYS9wcm9kdWN0Y29uZmlndXJh
dGlvbmFjdGlvblQvaW5kZXgucHZ0DR/T540=
--
# at 384766256
#170331 0:53:06 server id 1 end_log_pos 384766321 CRC32 0x6d190cb3 Anonymous_GTID last_committed=266209 sequence_number=266210
SET @@SESSION.GTID_NEXT= ‘ANONYMOUS‘/*!*/;
# at 384766321
#170331 0:53:06 server id 1 end_log_pos 384766398 CRC32 0x3d048d05 Query thread_id=315870 exec_time=0 error_code=0
原文：http://www.cnblogs.com/duanxz/p/6650401.html