Confirmed with Percona-Server-5.6.20-rel68.0-657.Linux.x86_64-debug. Some statements reset on 53 seconds but some continues .. mysql> show processlist; +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+-----------+---------------+ | 5 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 6 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 7 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 8 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 9 | root | localhost | test | Query | 102 | Waiting for table flush | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 10 | root | localhost | test | Query | 102 | Waiting for table flush | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 11 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 12 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 13 | root | localhost | test | Query | 51 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 14 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 15 | root | localhost | test | Query | 102 | Waiting for table flush | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 16 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 17 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 18 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 19 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 20 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 21 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 22 | root | localhost | test | Query | 102 | updating | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 23 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 24 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 25 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 26 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 27 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 28 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 29 | root | localhost | test | Query | 102 | Waiting for table flush | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 30 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 31 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 32 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 33 | root | localhost | test | Query | 51 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 34 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 35 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 36 | root | localhost | test | Query | 51 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 37 | root | localhost | test | Query | 51 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 38 | root | localhost | test | Query | 102 | Waiting for table flush | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 39 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 40 | root | localhost | test | Query | 51 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 41 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 42 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 43 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 44 | root | localhost | test | Query | 102 | Waiting for table flush | SELECT c1 FROM t1 | 0 | 0 | | 45 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 46 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 47 | root | localhost | test | Query | 51 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 48 | root | localhost | test | Query | 102 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 49 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 50 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 51 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 52 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 53 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 54 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 55 | root | localhost | test | Query | 51 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 56 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 57 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 58 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 59 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 60 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 61 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 62 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 63 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 64 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 65 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 66 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 67 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 68 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 69 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 70 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 71 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 72 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 73 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 74 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 75 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 76 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 77 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 78 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 79 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 80 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 81 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 82 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 83 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 84 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 85 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 86 | root | localhost | test | Query | 51 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 87 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 88 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 89 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 90 | root | localhost | test | Query | 51 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 91 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 92 | root | localhost | test | Query | 51 | Waiting for table flush | FLUSH TABLES | 0 | 0 | | 93 | root | localhost | test | Query | 102 | Waiting for table metadata lock | SELECT c1 FROM t1 | 0 | 0 | | 94 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 95 | root | localhost | test | Query | 102 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | 0 | 0 | | 96 | root | localhost | test | Query | 102 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 97 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 98 | root | localhost | test | Query | 51 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 99 | root | localhost | test | Query | 51 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | 0 | 0 | | 100 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 101 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 102 | root | localhost | test | Query | 102 | Waiting for table flush | SELECT c1 FROM t1 | 0 | 0 | | 103 | root | localhost | test | Query | 51 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | 0 | 0 | | 104 | root | localhost | test | Query | 102 | Waiting for table metadata lock | DROP TABLE t1 | 0 | 0 | | 105 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+-----------+---------------+ 101 rows in set (0.00 sec) mysql>