include/rpl_init.inc [topology=1 ->2 ->1 ]
include/rpl_connect.inc [creating M4]
include/rpl_connect.inc [creating M2]
connection M2;
STOP SLAVE;
SET @old_debug= @@global.debug_dbug;
SET GLOBAL debug_dbug= "d,dbug.rows_events_to_delay_relay_logging" ;
START SLAVE IO_THREAD;
include/wait_for_slave_io_to_start.inc
connection M2;
CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b VARCHAR(30000 )) ENGINE=innodb CHARSET=latin1;
connection M4;
connection M4;
INSERT INTO `t1` VALUES (null, repeat('a' , 1024 )), (null, repeat('b' , 1024 ));
connection M2;
SET debug_sync='now WAIT_FOR start_sql_thread' ;
START SLAVE SQL_THREAD;
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 AUTO_INCREMENT PRIMARY KEY, b VARCHAR(30000)) ENGINE=innodb CHARSET=latin1
SET debug_sync='now SIGNAL go_on_relay_logging' ;
connection M4;
connection M4;
connection M2;
connection M2;
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 AUTO_INCREMENT PRIMARY KEY, b VARCHAR(30000)) ENGINE=innodb CHARSET=latin1
slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
slave-bin.000001 # Annotate_rows # # INSERT INTO `t1` VALUES (null, repeat('a' , 1024 )), (null, repeat('b' , 1024 ))
slave-bin.000001 # Table_map # # table_id: # (test.t1)
slave-bin.000001 # Write_rows_v1 # # table_id: #
slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
slave-bin.000001 # Xid # # COMMIT /* XID */
connection M4;
drop table t1;
connection M2;
SET GLOBAL debug_dbug= @old_debug;
SET debug_sync='RESET' ;
include/rpl_end.inc
Messung V0.5 in Prozent C=53 H=99 G=79
¤ Dauer der Verarbeitung: 0.10 Sekunden
(vorverarbeitet am 2026-10-10)
¤
*© Formatika GbR, Deutschland