1 2 3 4 5 6 7 8 9 10 11 12 |
set @old_concurrent_insert= @@global.concurrent_insert; set @@global.concurrent_insert= 0; drop table if exists t1; create table t1 (kill_id int); insert into t1 values(connection_id()); flush tables with read lock; select ((@id := kill_id) - kill_id) from t1; ((@id := kill_id) - kill_id) 0 kill connection @id; drop table t1; set @@global.concurrent_insert= @old_concurrent_insert; |