| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
SET @old_debug_dbug= @@debug_dbug; |
| 4 |
SET @@debug_dbug="+d,simulate_big_table_id"; |
| 5 |
CREATE TABLE t (a int); |
| 6 |
INSERT INTO t SET a= 0; |
| 7 |
ALTER TABLE t comment ''; |
| 8 |
INSERT INTO t SET a= 1; |
| 9 |
ALTER TABLE t comment ''; |
| 10 |
INSERT INTO t SET a= 2; |
| 11 |
ALTER TABLE t comment ''; |
| 12 |
INSERT INTO t SET a= 3; |
| 13 |
show binlog events in <file> from <pos>; |
| 14 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 15 |
master-bin.000001 # Gtid 1 # BEGIN GTID #-#-# |
| 16 |
master-bin.000001 # Annotate_rows 1 # INSERT INTO t SET a= 0 |
| 17 |
master-bin.000001 # Table_map 1 # table_id: 4294967294 (test.t) |
| 18 |
master-bin.000001 # Write_rows_v1 1 # table_id: 4294967294 flags: STMT_END_F |
| 19 |
master-bin.000001 # Query 1 # COMMIT |
| 20 |
master-bin.000001 # Gtid 1 # GTID #-#-# |
| 21 |
master-bin.000001 # Query 1 # use `test`; ALTER TABLE t comment '' |
| 22 |
master-bin.000001 # Gtid 1 # BEGIN GTID #-#-# |
| 23 |
master-bin.000001 # Annotate_rows 1 # INSERT INTO t SET a= 1 |
| 24 |
master-bin.000001 # Table_map 1 # table_id: 4294967296 (test.t) |
| 25 |
master-bin.000001 # Write_rows_v1 1 # table_id: 4294967296 flags: STMT_END_F |
| 26 |
master-bin.000001 # Query 1 # COMMIT |
| 27 |
master-bin.000001 # Gtid 1 # GTID #-#-# |
| 28 |
master-bin.000001 # Query 1 # use `test`; ALTER TABLE t comment '' |
| 29 |
master-bin.000001 # Gtid 1 # BEGIN GTID #-#-# |
| 30 |
master-bin.000001 # Annotate_rows 1 # INSERT INTO t SET a= 2 |
| 31 |
master-bin.000001 # Table_map 1 # table_id: 4294967297 (test.t) |
| 32 |
master-bin.000001 # Write_rows_v1 1 # table_id: 4294967297 flags: STMT_END_F |
| 33 |
master-bin.000001 # Query 1 # COMMIT |
| 34 |
master-bin.000001 # Gtid 1 # GTID #-#-# |
| 35 |
master-bin.000001 # Query 1 # use `test`; ALTER TABLE t comment '' |
| 36 |
master-bin.000001 # Gtid 1 # BEGIN GTID #-#-# |
| 37 |
master-bin.000001 # Annotate_rows 1 # INSERT INTO t SET a= 3 |
| 38 |
master-bin.000001 # Table_map 1 # table_id: 4294967298 (test.t) |
| 39 |
master-bin.000001 # Write_rows_v1 1 # table_id: 4294967298 flags: STMT_END_F |
| 40 |
master-bin.000001 # Query 1 # COMMIT |
| 41 |
connection slave; |
| 42 |
connection master; |
| 43 |
SET debug_dbug=@old_debug_dbug; |
| 44 |
DROP TABLE t; |
| 45 |
connection slave; |
| 46 |
include/rpl_end.inc |