source include/master-slave.inc; connection master; CREATE TABLE t1 (data LONGBLOB) ENGINE=MYISAM; CREATE TABLE t2 (data LONGBLOB) ENGINE=MYISAM; INSERT INTO t1 (data) VALUES (repeat('a',1024*1024)); INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; sync_slave_with_master; connection master; send INSERT INTO t2 SELECT * FROM t1; connection master1; real_sleep 1; SET @id = 0; SELECT id INTO @id FROM information_schema.processlist WHERE info LIKE 'INSERT INTO t2%'; KILL CONNECTION @id; connection slave; wait_for_slave_to_stop; # The following should be 0 SELECT COUNT(*) FROM t2; --replace_result $MASTER_MYPORT MASTER_PORT --replace_column 1 # 7 # 8 # 9 # 22 # 23 # 33 # query_vertical show slave status;