include/master-slave.masterbin.000001 Gtid BEGIN GTID--#
[connection master]
CREATE TABLE t1 (a INT, b LONG);
INSERT INTO t1 VALUES (1 ,1 ), (2 ,2 );
INSERT INTO t1 VALUES (3 ,UUID()), (4 ,UUID());
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 # Gtid # # GTID #-#-#
master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b LONG)
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
master-bin.000001 # Query # # COMMIT
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3 ,UUID()), (4 ,UUID())
master-bin.000001 # Table_map # # table_id: # (test.t1)
master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # COMMIT
connection slave;
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
slave-bin.000001 # Gtid # # GTID #-#-#
slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b LONG)
slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
slave-bin.000001 # Query # # COMMIT
slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3 ,UUID()), (4 ,UUID())
slave-bin.000001 # Table_map # # table_id: # (test.t1)
slave-bin.000001 # Write_rows_v1 # master-in. #Query## use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (240, 2)
slave-bin.000001 # Query # # COMMIT
connection master;
DROP TABLE IF EXISTS t1;
include/rpl_end.inc
Messung V0.5 in Prozent C=74 H=99 G=87
¤ Dauer der Verarbeitung: 0.12 Sekunden
(vorverarbeitet am 2026-10-10)
¤
*© Formatika GbR, Deutschland