Binlog样例

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22

BEGIN
/*!*/;
# at 5273
#210728  0:53:03 server id 87904  end_log_pos 5346 CRC32 0x1a0ec140     Table_map: `xxl_job`.`xxl_job_registry` mapped to number 725
# at 5346
#210728  0:53:03 server id 87904  end_log_pos 5526 CRC32 0xaf71ae85     Update_rows: table id 725 flags: STMT_END_F
### UPDATE `xxl_job`.`xxl_job_registry`
### WHERE
###   @1=1374
###   @2='EXECUTOR'
###   @3='webapp'
###   @4='http://10.0.0.87:9999/'
###   @5='2021-07-28 00:52:34'
### SET
###   @1=1374
###   @2='EXECUTOR'
###   @3='webapp'
###   @4='http://10.0.0.87:9999/'
###   @5='2021-07-28 00:53:04'
# at 5526
#210728  0:53:03 server id 87903  end_log_pos 5557 CRC32 0xbfb76016     Xid = 657481860
COMMIT/*!*/;

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

BEGIN
/*!*/;
# at 1060
#210728  0:53:02 server id 87903  end_log_pos 1144 CRC32 0x486c5a15     Table_map: `xxl_job`.`xxl_job_log` mapped to number 722
# at 1144
#210728  0:53:02 server id 87903  end_log_pos 1216 CRC32 0x7efa9618     Write_rows: table id 722 flags: STMT_END_F
### INSERT INTO `xxl_job`.`xxl_job_log`
### SET
###   @1=22839500
###   @2=8
###   @3=11
###   @4=NULL
###   @5=NULL
###   @6=NULL
###   @7=NULL
###   @8=0
###   @9='2021-07-28 00:53:02'
###   @10=0
###   @11=NULL
###   @12=NULL
###   @13=0
###   @14=NULL
###   @15=0
# at 1216
#210728  0:53:02 server id 87903  end_log_pos 1247 CRC32 0xcb4903c2     Xid = 657481800
COMMIT/*!*/;

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

# at 161219344
#210728  9:10:09 server id 87903  end_log_pos 161219409 CRC32 0xaf35096e        GTID    last_committed=199604   sequence_number=199605  rbr_only=no
SET @@SESSION.GTID_NEXT= '8755ecf7-94df-11eb-b6c1-0c42a131f7ee:55181048'/*!*/;
# at 161219409
#210728  9:10:09 server id 87903  end_log_pos 161219491 CRC32 0x9440a612        Query   thread_id=15027222      exec_time=0     error_code=0
SET TIMESTAMP=1627434609/*!*/;
BEGIN
/*!*/;
# at 161219491
#210728  9:10:09 server id 87903  end_log_pos 161219573 CRC32 0x5eaa05c4        Table_map: `user_sys`.`member_account` mapped to number 550
# at 161219573
#210728  9:10:09 server id 87903  end_log_pos 161219670 CRC32 0x87692945        Delete_rows: table id 550 flags: STMT_END_F
### DELETE FROM `user_sys`.`member_account`
### WHERE
###   @1=1053
###   @2=108
###   @3='测试'
###   @4=1627434609794
###   @5=261
###   @6=127
###   @7=2
# at 161219670
#210728  9:10:09 server id 87903  end_log_pos 161219701 CRC32 0x846311dd        Xid = 659607697
COMMIT/*!*/;