15
15
show binlog events from <binlog_start>;
16
16
Log_name Pos Event_type Server_id End_log_pos Info
17
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1), (1,2), (2,1), (2,2)
18
master-bin.000001 # Query # # use `test`; BEGIN
19
master-bin.000001 # Query # # use `test`; INSERT INTO t2 VALUES (1,1), (1,2), (2,1), (2,2)
20
master-bin.000001 # Query # # use `test`; COMMIT
21
master-bin.000001 # Query # # use `test`; UPDATE t1, t2 SET m = 2, b = 3 WHERE n = c
22
master-bin.000001 # Query # # use `test`; BEGIN
23
master-bin.000001 # Query # # use `test`; INSERT INTO t3 VALUES (1,1), (1,2), (2,1), (2,2)
24
master-bin.000001 # Query # # use `test`; UPDATE t1, t3 SET m = 2, e = 3 WHERE n = f
25
master-bin.000001 # Query # # use `test`; UPDATE t3, t2 SET e = 2, b = 3 WHERE f = c
26
master-bin.000001 # Query # # use `test`; COMMIT
27
master-bin.000001 # Query # # BEGIN
28
master-bin.000001 # Table_map # # table_id: # (test.t3)
29
master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
30
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
31
master-bin.000001 # Query # # COMMIT
17
mysqld-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1), (1,2), (2,1), (2,2)
18
mysqld-bin.000001 # Query # # use `test`; BEGIN
19
mysqld-bin.000001 # Query # # use `test`; INSERT INTO t2 VALUES (1,1), (1,2), (2,1), (2,2)
20
mysqld-bin.000001 # Query # # use `test`; COMMIT
21
mysqld-bin.000001 # Query # # use `test`; UPDATE t1, t2 SET m = 2, b = 3 WHERE n = c
22
mysqld-bin.000001 # Query # # use `test`; BEGIN
23
mysqld-bin.000001 # Query # # use `test`; INSERT INTO t3 VALUES (1,1), (1,2), (2,1), (2,2)
24
mysqld-bin.000001 # Query # # use `test`; UPDATE t1, t3 SET m = 2, e = 3 WHERE n = f
25
mysqld-bin.000001 # Query # # use `test`; UPDATE t3, t2 SET e = 2, b = 3 WHERE f = c
26
mysqld-bin.000001 # Query # # use `test`; COMMIT
27
mysqld-bin.000001 # Query # # BEGIN
28
mysqld-bin.000001 # Table_map # # table_id: # (test.t3)
29
mysqld-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
30
mysqld-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
31
mysqld-bin.000001 # Query # # COMMIT
32
32
DROP TABLE t1, t2, t3;