2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
set @old_global_binlog_format = @@global.binlog_format;
8
set @@global.binlog_format = statement;
9
CREATE SCHEMA IF NOT EXISTS mysqlslap;
11
select @@global.binlog_format;
12
@@global.binlog_format
14
CREATE TABLE t1 (id INT primary key auto_increment, name VARCHAR(64));
16
SELECT COUNT(*) FROM t1;
20
SELECT COUNT(*) FROM t1;
24
insert delayed into t1 values(10, "my name");
25
insert delayed into t1 values(10, "is Bond"), (20, "James Bond");
26
ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
34
delete from t1 where id!=10;
35
insert delayed into t1 values(20, "is Bond"), (10, "James Bond");
36
ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
47
DROP SCHEMA mysqlslap;
51
CREATE TABLE t1(a int, UNIQUE(a));
52
INSERT DELAYED IGNORE INTO t1 VALUES(1);
53
INSERT DELAYED IGNORE INTO t1 VALUES(1);
55
show binlog events in 'master-bin.000002' LIMIT 2,2;
56
Log_name Pos Event_type Server_id End_log_pos Info
57
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
58
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
63
show binlog events in 'slave-bin.000002' LIMIT 2,2;
64
Log_name Pos Event_type Server_id End_log_pos Info
65
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
66
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
74
set @@global.binlog_format = mixed;
75
CREATE SCHEMA IF NOT EXISTS mysqlslap;
77
select @@global.binlog_format;
78
@@global.binlog_format
80
CREATE TABLE t1 (id INT primary key auto_increment, name VARCHAR(64));
82
SELECT COUNT(*) FROM t1;
86
SELECT COUNT(*) FROM t1;
90
insert delayed into t1 values(10, "my name");
91
insert delayed into t1 values(10, "is Bond"), (20, "James Bond");
101
delete from t1 where id!=10;
102
insert delayed into t1 values(20, "is Bond"), (10, "James Bond");
113
DROP SCHEMA mysqlslap;
117
CREATE TABLE t1(a int, UNIQUE(a));
118
INSERT DELAYED IGNORE INTO t1 VALUES(1);
119
INSERT DELAYED IGNORE INTO t1 VALUES(1);
121
show binlog events in 'master-bin.000002' LIMIT 2,2;
122
Log_name Pos Event_type Server_id End_log_pos Info
123
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
124
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
129
show binlog events in 'slave-bin.000002' LIMIT 2,2;
130
Log_name Pos Event_type Server_id End_log_pos Info
131
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
132
x x x x x use `test`; INSERT DELAYED IGNORE INTO t1 VALUES(1)
140
set @@global.binlog_format = @old_global_binlog_format;