stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; set @old_global_binlog_format = @@global.binlog_format; set @@global.binlog_format = statement; CREATE SCHEMA IF NOT EXISTS mysqlslap; USE mysqlslap; select @@global.binlog_format; @@global.binlog_format STATEMENT CREATE TABLE t1 (id INT primary key auto_increment, name VARCHAR(64)); FLUSH TABLE t1; SELECT COUNT(*) FROM t1; COUNT(*) 5000 use mysqlslap; SELECT COUNT(*) FROM t1; COUNT(*) 5000 truncate table t1; insert delayed into t1 values(10, "my name"); insert delayed into t1 values(10, "is Bond"), (20, "James Bond"); ERROR 23000: Duplicate entry '10' for key 'PRIMARY' flush table t1; select * from t1; id name 10 my name select * from t1; id name 10 my name delete from t1 where id!=10; insert delayed into t1 values(20, "is Bond"), (10, "James Bond"); ERROR 23000: Duplicate entry '10' for key 'PRIMARY' flush table t1; select * from t1; id name 10 my name 20 is Bond select * from t1; id name 10 my name 20 is Bond USE test; DROP SCHEMA mysqlslap; use test; FLUSH LOGS; FLUSH LOGS; CREATE TABLE t1(a int, UNIQUE(a)); INSERT DELAYED IGNORE INTO t1 VALUES(1); INSERT DELAYED IGNORE INTO t1 VALUES(1); flush table t1; show binlog events in 'master-bin.000002' from <binlog_start> limit 1,2; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Query # # use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1) master-bin.000002 # Query # # use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1) select * from t1; a 1 On slave show binlog events in 'slave-bin.000002' from <binlog_start> limit 1,2; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000002 # Query # # use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1) slave-bin.000002 # Query # # use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1) select * from t1; a 1 drop table t1; FLUSH LOGS; FLUSH LOGS; End of 5.0 tests set @@global.binlog_format = mixed; CREATE SCHEMA IF NOT EXISTS mysqlslap; USE mysqlslap; select @@global.binlog_format; @@global.binlog_format MIXED CREATE TABLE t1 (id INT primary key auto_increment, name VARCHAR(64)); FLUSH TABLE t1; SELECT COUNT(*) FROM t1; COUNT(*) 5000 use mysqlslap; SELECT COUNT(*) FROM t1; COUNT(*) 5000 truncate table t1; insert delayed into t1 values(10, "my name"); insert delayed into t1 values(10, "is Bond"), (20, "James Bond"); flush table t1; select * from t1; id name 10 my name 20 James Bond select * from t1; id name 10 my name 20 James Bond delete from t1 where id!=10; insert delayed into t1 values(20, "is Bond"), (10, "James Bond"); flush table t1; select * from t1; id name 10 my name 20 is Bond select * from t1; id name 10 my name 20 is Bond USE test; DROP SCHEMA mysqlslap; use test; CREATE TABLE t1(a int, UNIQUE(a)); INSERT DELAYED IGNORE INTO t1 VALUES(1); INSERT DELAYED IGNORE INTO t1 VALUES(1); flush table t1; select * from t1; a 1 On slave select * from t1; a 1 drop table t1; FLUSH LOGS; FLUSH LOGS; End of 5.0 tests set @@global.binlog_format = @old_global_binlog_format;