// Build used commit: df34098068ae4a07f245ad13a4819ca01bde71df date: 2014-11-18 09:54:31 +0530 build-date: 2014-11-18 18:01:47 +0100 short: df34098 branch: mysql-5.6 MySQL source 5.6.23 // Start up scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/73829 bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/73829 --core-file --socket=/tmp/73829.sock --port=15000 --log-error=/export/umesh/mysql-5.6.23/73829/log.err 2>&1 & // Session 1 mysql> show variables like '%version%'; +-------------------------+---------------------------------------------------------------+ | Variable_name | Value | +-------------------------+---------------------------------------------------------------+ | innodb_version | 5.6.23 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.6.23-enterprise-commercial-advanced-debug | | version_comment | MySQL Enterprise Server - Advanced Edition Debug (Commercial) | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+---------------------------------------------------------------+ 7 rows in set (0.00 sec) // Session 2 [umshastr@hod03]/export/umesh/setups: ./pquery-ms --infile=generator/out.2 --database=test --threads=100 --verbose --user=root --socket=/tmp/73829.sock // Session 1 mysql> show processlist; +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+ | 1 | root | localhost | NULL | Query | 0 | init | show processlist | | 3 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 4 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DROP TABLE t2 | | 5 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 6 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 7 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 8 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 9 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 10 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 11 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 12 | root | localhost | test | Query | 98 | Waiting for table flush | SELECT c1 FROM t2 | | 13 | root | localhost | test | Query | 98 | Waiting for table flush | SELECT c1 FROM t2 | | 14 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 15 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 16 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 17 | root | localhost | test | Query | 98 | Waiting for table flush | INSERT INTO t2 VALUES (1,2,3) | | 18 | root | localhost | test | Query | 98 | Waiting for table flush | FLUSH TABLES | | 19 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 20 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 21 | root | localhost | test | Query | 47 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 22 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 23 | root | localhost | test | Query | 98 | Waiting for table flush | SELECT c1 FROM t2 | | 24 | root | localhost | test | Query | 47 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 25 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 26 | root | localhost | test | Query | 98 | Waiting for table flush | INSERT INTO t2 VALUES (1,2,3) | | 27 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 28 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 29 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 30 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 31 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 32 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 33 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 34 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 35 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 36 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 37 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 38 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DROP TABLE t2 | | 39 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 40 | root | localhost | test | Query | 47 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 41 | root | localhost | test | Query | 98 | Waiting for table flush | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 42 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 43 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 44 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 45 | root | localhost | test | Query | 98 | Waiting for table flush | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 46 | root | localhost | test | Query | 98 | Waiting for table flush | INSERT INTO t2 VALUES (1,2,3) | | 47 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 48 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 49 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 50 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 51 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 52 | root | localhost | test | Query | 47 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 53 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 54 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 55 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 56 | root | localhost | test | Query | 47 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 57 | root | localhost | test | Query | 47 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 58 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 59 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 60 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 61 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 62 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 63 | root | localhost | test | Query | 98 | Waiting for table flush | SELECT c1 FROM t2 | | 64 | root | localhost | test | Query | 47 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 65 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 66 | root | localhost | test | Query | 47 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 67 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 68 | root | localhost | test | Query | 98 | Waiting for table flush | INSERT INTO t2 VALUES (1,2,3) | | 69 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 70 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 71 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 72 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 73 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 74 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 75 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DROP TABLE t2 | | 76 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DROP TABLE t2 | | 77 | root | localhost | test | Query | 47 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 78 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 79 | root | localhost | test | Query | 98 | Waiting for table flush | SELECT c1 FROM t2 | | 80 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 81 | root | localhost | test | Query | 98 | Waiting for table flush | SELECT c1 FROM t2 | | 82 | root | localhost | test | Query | 98 | Waiting for table flush | DELETE FROM t2 LIMIT 1 | | 83 | root | localhost | test | Query | 47 | Waiting for table metadata lock | DROP TABLE t2 | | 84 | root | localhost | test | Query | 98 | Waiting for table flush | INSERT INTO t2 VALUES (1,2,3) | | 85 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 86 | root | localhost | test | Query | 47 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 87 | root | localhost | test | Query | 98 | Waiting for table flush | INSERT INTO t2 VALUES (1,2,3) | | 88 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 89 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 90 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 91 | root | localhost | test | Query | 47 | Waiting for table flush | FLUSH TABLES | | 92 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 93 | root | localhost | test | Query | 98 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 94 | root | localhost | test | Query | 47 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 95 | root | localhost | test | Query | 47 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 96 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 97 | root | localhost | test | Query | 98 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 98 | root | localhost | test | Query | 98 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 99 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 100 | root | localhost | test | Query | 98 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 101 | root | localhost | test | Query | 98 | updating | DELETE FROM t2 LIMIT 1 | | 102 | root | localhost | test | Query | 98 | Waiting for table flush | FLUSH TABLES | +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+ 101 rows in set (0.00 sec) // 5.7.6 bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/75057 -v bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/75057 --core-file --socket=/tmp/75057.sock --port=15000 --log-error=/export/umesh/mysql-5.7.6/75057/log.err 2>&1 & // build used commit: 1982dd7ab813e3cdb28d3bb119cc7b706cf01b15 date: 2014-11-27 13:27:39 +0300 build-date: 2014-11-27 12:38:45 +0100 short: 1982dd7 branch: mysql-trunk MySQL source 5.7.6 mysql> show variables like '%version%'; +-------------------------+---------------------------------------------------------------+ | Variable_name | Value | +-------------------------+---------------------------------------------------------------+ | innodb_version | 5.7.6 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.7.6-m16-enterprise-commercial-advanced-debug | | version_comment | MySQL Enterprise Server - Advanced Edition Debug (Commercial) | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+---------------------------------------------------------------+ 7 rows in set (0.00 sec) mysql> show processlist; +----+------+-----------+------+---------+------+----------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+------+---------+------+----------+------------------+ | 1 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+------+-----------+------+---------+------+----------+------------------+ 1 row in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+ | 1 | root | localhost | NULL | Query | 0 | starting | show processlist | | 3 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 4 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 5 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 6 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 7 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 8 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 9 | root | localhost | test | Query | 101 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 10 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 11 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 12 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 13 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 14 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 15 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DROP TABLE t2 | | 16 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t2 | | 17 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t1 | | 18 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t2 | | 19 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 20 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DROP TABLE t2 | | 21 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 22 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | | 23 | root | localhost | test | Query | 101 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 24 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 25 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 26 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 27 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 28 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 29 | root | localhost | test | Query | 50 | Waiting for table flush | FLUSH TABLES | | 30 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | | 31 | root | localhost | test | Query | 50 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1,2,3) | | 32 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 33 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 34 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 35 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 36 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t1 | | 37 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 38 | root | localhost | test | Query | 152 | updating | DELETE FROM t2 LIMIT 1 | | 39 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 40 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 41 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 42 | root | localhost | test | Query | 101 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 43 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 44 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 45 | root | localhost | test | Query | 101 | Waiting for table metadata lock | SELECT c1 FROM t1 | | 46 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 47 | root | localhost | test | Query | 101 | Waiting for table metadata lock | SELECT c1 FROM t1 | | 48 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 49 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 50 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t1 | | 51 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DROP TABLE t2 | | 52 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 53 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 54 | root | localhost | test | Query | 50 | Waiting for table flush | FLUSH TABLES | | 55 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 56 | root | localhost | test | Query | 101 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 57 | root | localhost | test | Query | 50 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 58 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 59 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | | 60 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 61 | root | localhost | test | Query | 101 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 62 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 63 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 64 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DROP TABLE t2 | | 65 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 66 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 67 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 68 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t1 | | 69 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 70 | root | localhost | test | Query | 101 | Waiting for table metadata lock | SELECT c1 FROM t1 | | 71 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 72 | root | localhost | test | Query | 50 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | | 73 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 74 | root | localhost | test | Query | 101 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 75 | root | localhost | test | Query | 50 | Waiting for table metadata lock | SELECT c1 FROM t1 | | 76 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t2 | | 77 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 78 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 79 | root | localhost | test | Query | 50 | Waiting for table flush | SELECT c1 FROM t2 | | 80 | root | localhost | test | Query | 50 | Waiting for table flush | FLUSH TABLES | | 81 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 82 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 83 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 84 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DROP TABLE t2 | | 85 | root | localhost | test | Query | 101 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 86 | root | localhost | test | Query | 101 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 87 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 88 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 89 | root | localhost | test | Query | 152 | Waiting for table metadata lock | SELECT c1 FROM t2 | | 90 | root | localhost | test | Query | 152 | Waiting for table metadata lock | INSERT INTO t2 VALUES (1,2,3) | | 91 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | | 92 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DROP TABLE t2 | | 93 | root | localhost | test | Query | 50 | Waiting for table metadata lock | DROP TABLE t2 | | 94 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t2 | | 95 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DELETE FROM t2 LIMIT 1 | | 96 | root | localhost | test | Query | 50 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 97 | root | localhost | test | Query | 152 | Waiting for table metadata lock | DROP TABLE t2 | | 98 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DELETE FROM t1 LIMIT 1 | | 99 | root | localhost | test | Query | 101 | Waiting for table metadata lock | DROP TABLE t1 | | 100 | root | localhost | test | Query | 50 | Waiting for table metadata lock | SELECT c1 FROM t1 | | 101 | root | localhost | test | Query | 152 | Waiting for table metadata lock | CREATE TABLE t2 (c1 INT,c2 INT,c3 INT) | | 102 | root | localhost | test | Query | 101 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT,c2 INT,c3 INT) | +-----+------+-----------+------+---------+------+---------------------------------+----------------------------------------+ 101 rows in set (0.00 sec)