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
create table t1i(n int primary key) engine=innodb;
8
create table t2m(n int primary key) engine=myisam;
10
insert into t1i values (1);
11
insert into t1i values (2);
12
insert into t1i values (3);
15
insert into t1i values (5);
17
insert into t1i values (4);
18
insert into t2m values (1);
19
update t1i set n = 5 where n = 4;
23
*** kill sql thread ***
25
*** sql thread is *not* running: No ***
26
*** the prove: the killed slave has not finished the current transaction ***
34
start slave sql_thread;
38
insert into t1i values (5);
40
insert into t1i values (4);
41
update t1i set n = 5 where n = 4;
45
stop slave sql_thread;
47
*** sql thread is *not* running: No ***
48
*** the prove: the stopped slave has rolled back the current transaction ***
55
start slave sql_thread;