1reset master; 2create table t1 (a int not null auto_increment, primary key (a)) engine=myisam; 3insert /* before delayed */ delayed /* after delayed */ into t1 values (207); 4insert /*! delayed */ into t1 values (null); 5insert delayed into t1 values (300); 6FLUSH TABLES; 7include/show_binlog_events.inc 8Log_name Pos Event_type Server_id End_log_pos Info 9master-bin.000001 # Gtid # # GTID #-#-# 10master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam 11master-bin.000001 # Gtid # # BEGIN GTID #-#-# 12master-bin.000001 # Query # # use `test`; insert /* before delayed */ /* after delayed */ into t1 values (207) 13master-bin.000001 # Query # # COMMIT 14master-bin.000001 # Gtid # # BEGIN GTID #-#-# 15master-bin.000001 # Intvar # # INSERT_ID=208 16master-bin.000001 # Query # # use `test`; insert /*! */ into t1 values (null) 17master-bin.000001 # Query # # COMMIT 18master-bin.000001 # Gtid # # BEGIN GTID #-#-# 19master-bin.000001 # Query # # use `test`; insert into t1 values (300) 20master-bin.000001 # Query # # COMMIT 21master-bin.000001 # Gtid # # GTID #-#-# 22master-bin.000001 # Query # # use `test`; FLUSH TABLES 23RESET MASTER; 24insert /* before delayed */ delayed /* after delayed */ into t1 values (null),(null),(null),(null); 25insert /*! delayed */ into t1 values (null),(null),(400),(null); 26FLUSH TABLES; 27include/show_binlog_events.inc 28Log_name Pos Event_type Server_id End_log_pos Info 29master-bin.000001 # Gtid # # BEGIN GTID #-#-# 30master-bin.000001 # Intvar # # INSERT_ID=301 31master-bin.000001 # Query # # use `test`; insert /* before delayed */ /* after delayed */ into t1 values (null),(null),(null),(null) 32master-bin.000001 # Query # # COMMIT 33master-bin.000001 # Gtid # # BEGIN GTID #-#-# 34master-bin.000001 # Intvar # # INSERT_ID=305 35master-bin.000001 # Query # # use `test`; insert /*! */ into t1 values (null),(null),(400),(null) 36master-bin.000001 # Query # # COMMIT 37master-bin.000001 # Gtid # # GTID #-#-# 38master-bin.000001 # Query # # use `test`; FLUSH TABLES 39select * from t1; 40a 41207 42208 43300 44301 45302 46303 47304 48305 49306 50400 51401 52drop table t1; 53reset master; 54