drop table if exists numbers,temp1,temp2; create table numbers (f1 int not null auto_increment primary key); insert into numbers values(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(); insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; insert into numbers select 0 from numbers; create table temp1 select * from numbers; create table temp2 select * from numbers; send select count(*) from temp1 as a, temp1 as b, temp1 as c where (a.f1-b.f1)*c.f1 = 0; connect (addconroot, localhost, root,,); connection addconroot; sleep 2; send rename table temp1 to temp3, temp2 to temp1; connect (addconroot2, localhost, root,,); connection addconroot2; send select count(*) from temp1 as a, temp1 as b, temp1 as c where a.f1+b.f1+c.f1 = 0; connect (addconroot3, localhost, root,,); connection addconroot3; sleep 2; show processlist; kill 2; sleep 2; show processlist; sleep 2; show processlist; sleep 20; show processlist;