mysql> show processlist;
+-----+------+-----------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
| Id  | User | Host      | db   | Command | Time | State                           | Info                                                                                                 |
+-----+------+-----------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
|   2 | root | localhost | test | Query   |    0 | starting                        | show processlist                                                                                     |
|   8 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1.e+10,1.e-1,10-10-2014)                                                      |
|   9 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 NUMERIC(65) UNSIGNED ZEROFILL,c2 ENUM('a','b','c') CHARACTER SET "utf8" COLLATE  |
|  10 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 BIT PRIMARY KEY,c2 DECIMAL(1) UNSIGNED,c3 MULTIPOLYGON) ENGINE=InnoDB            |
|  11 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (0.01,1,1e3)                                                                   |
|  12 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1 AS a1, t3 AS a2                                                                 |
|  13 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 VARCHAR(256) PRIMARY KEY,c2 DOUBLE UNSIGNED,c3 BIGINT UNSIGNED ZEROFILL) ENGINE= |
|  14 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t1 (c1 BIT PRIMARY KEY,c2 DECIMAL(1) UNSIGNED,c3 MULTIPOLYGON) ENGINE=InnoDB            |
|  15 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES (0.00001,0.001,2)                                                              |
|  16 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES (10-10-2014,'cCCCCc',1500)                                                     |
|  17 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 INT(10),c2 BIGINT(1) UNSIGNED,c3 YEAR) ENGINE=MEMORY                             |
|  18 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 BINARY PRIMARY KEY,c2 TIMESTAMP(0),c3 TIME(0)) ENGINE=InnoDB                     |
|  19 | root | localhost | test | Query   |   48 | updating                        | UPDATE t2 SET c1='CC'                                                                                |
|  20 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
|  21 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 NUMERIC(1) UNSIGNED,c2 POINT,c3 CHAR CHARACTER SET "Binary" COLLATE "Binary", PR |
|  22 | root | localhost | test | Query   |   48 | updating                        | UPDATE t2 SET c1=3                                                                                   |
|  23 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES ('EEeeEE','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa',- |
|  24 | root | localhost | test | Query   |   48 | Waiting for table metadata lock | DELETE a3,a1 FROM t2 AS a1 CROSS JOIN t1 AS a2 CROSS JOIN t2 AS a3                                   |
|  25 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 DECIMAL(10),c2 TEXT,c3 LINESTRING, PRIMARY KEY(c1)) ENGINE=TokuDB                |
|  26 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | UPDATE t1 SET c1=23-12-2340 WHERE c1=c1 ORDER BY c2 DESC                                             |
|  27 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | UPDATE t1 SET c1='23-12-2015' WHERE c3>c1 LIMIT 9                                                    |
|  28 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 VARCHAR(256) PRIMARY KEY,c2 DOUBLE UNSIGNED,c3 BIGINT UNSIGNED ZEROFILL) ENGINE= |
|  29 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DELETE a2,a1 FROM t1 AS a1, t2 AS a2, t3 AS a3                                                       |
|  30 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t1 (c1 DECIMAL PRIMARY KEY,c2 FLOAT(1,1) UNSIGNED ZEROFILL,c3 MEDIUMBLOB) ENGINE=MyISAM |
|  31 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
|  32 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa',2990,2)    |
|  33 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t1 (c1 YEAR,c2 INT(255),c3 BLOB) ENGINE=MyISAM                                          |
|  34 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DELETE IGNORE a3 FROM t1 AS a1, t2 AS a2, t3 AS a3                                                   |
|  35 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
|  36 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t2 VALUES ('\0xe','c',-1.e+2)                                                            |
|  37 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | ALTER TABLE t2 ADD UNIQUE (c3)                                                                       |
|  38 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t2 VALUES (-1.e+20,1.e-20,1)                                                             |
|  39 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 VARCHAR(1) CHARACTER SET "latin1" COLLATE "latin1_bin",c2 DATETIME(3),c3 JSON, P |
|  40 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (0.0001,-3,1)                                                                  |
|  41 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
|  42 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | ALTER TABLE t2 MODIFY c3 TIMESTAMP(5)                                                                |
|  43 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES ('a',-1.e+20,23-12-2015)                                                       |
|  44 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | ALTER TABLE t1 MODIFY c3 BIGINT(254)                                                                 |
|  45 | root | localhost | test | Query   |   48 | updating                        | UPDATE t2 SET c1='c'                                                                                 |
|  46 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (12-23-2340,0.1,12-23-2340)                                                    |
|  47 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 DECIMAL PRIMARY KEY,c2 JSON,c3 CHAR(255) BINARY) ENGINE=MEMORY                   |
|  48 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t1 (c1 TINYINT(2),c2 TINYINT(1),c3 INTEGER(1) UNSIGNED, PRIMARY KEY(c1)) ENGINE=MEMORY  |
|  49 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 MEDIUMINT(254) UNSIGNED ZEROFILL,c2 VARCHAR(254) BINARY CHARACTER SET "latin1" C |
|  50 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (2.0,1.e+20,NULL)                                                              |
|  51 | root | localhost | test | Query   |   48 | updating                        | UPDATE t2 SET c1='ffFFff'                                                                            |
|  52 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
|  53 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1 FROM t1                                                                                    |
|  54 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t2 VALUES ('x05',1.e+2,'ffFFff')                                                         |
|  55 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | UPDATE t2 SET c1=NULL                                                                                |
|  56 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 NUMERIC(10,10) UNSIGNED,c2 VARCHAR(2037) CHARACTER SET "latin1" COLLATE "latin1_ |
|  57 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
|  58 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | DROP TABLE t2                                                                                        |
|  59 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | ALTER TABLE t3 DROP PRIMARY KEY                                                                      |
|  60 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES ('CC',1.e-30,-1.e+30)                                                          |
|  61 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 DECIMAL PRIMARY KEY,c2 ENUM('a','b','c'),c3 DECIMAL(2) UNSIGNED ZEROFILL) ENGINE |
|  62 | root | localhost | test | Query   |   48 | System lock                     | UPDATE t2 SET c1=-1.e+20 ORDER BY c2 ASC                                                             |
|  63 | root | localhost | test | Query   |   48 | updating                        | UPDATE t2 SET c1=3                                                                                   |
|  64 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (-1.e+10,3.1415927,2014)                                                       |
|  65 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t2 VALUES ('DddddD','12-23-2015',1e2)                                                    |
|  66 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | TRUNCATE t1                                                                                          |
|  67 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 TINYINT(2),c2 TINYINT(1),c3 INTEGER(1) UNSIGNED, PRIMARY KEY(c1)) ENGINE=MEMORY  |
|  68 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | UPDATE t3 SET c1=3.0 LIMIT 7                                                                         |
|  69 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1 FROM t1                                                                                    |
|  70 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t1 VALUES (-1.e+3,-3.0,-1.e+10)                                                          |
|  71 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1 AS a1 JOIN t3 AS a2 WHERE a1.c3<a1.c2                                           |
|  72 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (-3,1e3,1.e+2)                                                                 |
|  73 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | DROP TABLE t2                                                                                        |
|  74 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | ALTER TABLE t2 ADD UNIQUE (c1)                                                                       |
|  75 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
|  76 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | TRUNCATE t1                                                                                          |
|  77 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (-1.e+3,-3.0,-1.e+10)                                                          |
|  78 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | TRUNCATE t1                                                                                          |
|  79 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | TRUNCATE t2                                                                                          |
|  80 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES (-2,2990,'aAaAaA')                                                             |
|  81 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t1 (c1 REAL UNSIGNED ZEROFILL,c2 NUMERIC(2) ZEROFILL,c3 TIME(2), PRIMARY KEY(c1)) ENGIN |
|  82 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
|  83 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (3.1415927,'x05',1.e+2)                                                        |
|  84 | root | localhost | test | Query   |   46 | updating                        | UPDATE t2 SET c1=NULL                                                                                |
|  85 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | DROP TABLE t2                                                                                        |
|  86 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 CHAR(1) PRIMARY KEY,c2 MEDIUMTEXT BINARY CHARACTER SET "Binary" COLLATE "Binary" |
|  87 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t2 VALUES ('b','cc',-2)                                                                  |
|  88 | root | localhost | test | Query   |   48 | updating                        | UPDATE t2 SET c1='23-12-2340'                                                                        |
|  89 | root | localhost | test | Query   |   48 | Waiting for table metadata lock | DELETE LOW_PRIORITY a3,a2 FROM t1 AS a1, t2 AS a2, t3 AS a3                                          |
|  90 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 CHAR(255) PRIMARY KEY,c2 TINYBLOB,c3 BIGINT(254) UNSIGNED ZEROFILL) ENGINE=InnoD |
|  91 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1.e-3,'12-23-2340','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
|  92 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1 FROM t1                                                                                    |
|  93 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DELETE a2 FROM t3 AS a1, t1 AS a2, t2 AS a3 WHERE a1.c3=a3.c3                                        |
|  94 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | TRUNCATE t1                                                                                          |
|  95 | root | localhost | test | Query   |   46 | updating                        | UPDATE t2 SET c1='c'                                                                                 |
|  96 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | TRUNCATE t1                                                                                          |
|  97 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
|  98 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 CHAR(255) PRIMARY KEY,c2 VARCHAR(254),c3 BIGINT(1) UNSIGNED) ENGINE=TokuDB       |
|  99 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 VARCHAR(40) BINARY CHARACTER SET "Binary" COLLATE "Binary",c2 TIME,c3 DECIMAL(65 |
| 100 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 DECIMAL PRIMARY KEY,c2 TIMESTAMP(2),c3 TINYBLOB) ENGINE=MyISAM                   |
| 101 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | UPDATE t1 SET c1=1.e+10                                                                              |
| 102 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | FLUSH LOCAL TABLES t3 WITH READ LOCK                                                                 |
| 103 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 BIT PRIMARY KEY,c2 DATE,c3 FLOAT(10,10)) ENGINE=InnoDB                           |
| 104 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | TRUNCATE t1                                                                                          |
| 105 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DELETE IGNORE a3 FROM t1 AS a1, t3 AS a2, t1 AS a3 WHERE a2.c2=-1.e+1                                |
| 106 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t1 (c1 CHAR(2) BINARY,c2 CHAR(10) BINARY,c3 LONGTEXT BINARY) ENGINE=InnoDB              |
| 107 | root | localhost | test | Query   |   47 | updating                        | UPDATE t2 SET c1=1.e-20                                                                              |
| 108 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES ('cc','a',-1.e-10)                                                             |
| 109 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 CHAR(254) PRIMARY KEY,c2 SET('a','b','c') CHARACTER SET "utf8" COLLATE "utf8_bin |
| 110 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 VARCHAR(120) PRIMARY KEY,c2 VARCHAR(10) BINARY CHARACTER SET "Binary" COLLATE "B |
| 111 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | TRUNCATE t1                                                                                          |
| 112 | root | localhost | test | Query   |   48 | updating                        | UPDATE t2 SET c1=NULL                                                                                |
| 113 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
| 114 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 YEAR,c2 NUMERIC(65),c3 DOUBLE UNSIGNED) ENGINE=TokuDB                            |
| 115 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1 FROM t1                                                                                    |
| 116 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 CHAR(254) PRIMARY KEY,c2 SET('a','b','c') CHARACTER SET "utf8" COLLATE "utf8_bin |
| 117 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | ALTER TABLE t1 DROP COLUMN c3                                                                        |
| 118 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | UPDATE t1 SET c1=1e2                                                                                 |
| 119 | root | localhost | test | Query   |   46 | Sending data                    | DELETE a1,a2 FROM t2 AS a1 NATURAL RIGHT OUTER JOIN t2 AS a2 NATURAL LEFT JOIN t3 AS a3 WHERE a2.c2= |
| 120 | root | localhost | test | Query   |   47 | updating                        | UPDATE t2 SET c1=NULL                                                                                |
| 121 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 CHAR(255) PRIMARY KEY,c2 REAL(2,2),c3 DECIMAL(1) UNSIGNED ZEROFILL) ENGINE=MEMOR |
| 122 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 TINYTEXT,c2 BIGINT(1) ZEROFILL,c3 DECIMAL(2,2) UNSIGNED) ENGINE=InnoDB           |
| 123 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 DATETIME(5),c2 DECIMAL(10,10) UNSIGNED ZEROFILL,c3 VARCHAR(254) BINARY CHARACTER |
| 124 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES (3,1.e-3,NULL)                                                                 |
| 125 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
| 126 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | ALTER TABLE t3 DROP PRIMARY KEY                                                                      |
| 127 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | UPDATE t1 SET c1='c'                                                                                 |
| 128 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t3 VALUES (0.00001,0.001,2)                                                              |
| 129 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa',1.e+3,'Ddd |
| 130 | root | localhost | test | Query   |   46 | updating                        | UPDATE t2 SET c1='CC'                                                                                |
| 131 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | ALTER TABLE t3 MODIFY c2 DECIMAL(1)                                                                  |
| 132 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t1 (c1 DECIMAL PRIMARY KEY,c2 TIMESTAMP(2),c3 TINYBLOB) ENGINE=MyISAM                   |
| 133 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | UPDATE t1 SET c1=1000000000000000 WHERE c2>='XYZ' ORDER BY c1 ASC LIMIT 9                            |
| 134 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1 FROM t1                                                                                    |
| 135 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1 FROM t1                                                                                    |
| 136 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
| 137 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
| 138 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
| 139 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 TIME,c2 CHAR(255) CHARACTER SET "latin1" COLLATE "latin1_bin",c3 REAL(255,10) ZE |
| 140 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | CREATE TABLE t2 (c1 BINARY,c2 MULTIPOINT,c3 BLOB) ENGINE=InnoDB                                      |
| 141 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (-1.e-20,'12-23-2340',1.e+10)                                                  |
| 142 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 REAL UNSIGNED ZEROFILL,c2 NUMERIC(2) ZEROFILL,c3 TIME(2), PRIMARY KEY(c1)) ENGIN |
| 143 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t1 VALUES ('b','23-12-2340',1.e-10)                                                      |
| 144 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t2 VALUES ('12-23-2015',12-23-2015,-1.0)                                                 |
| 145 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
| 146 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | SELECT c1,c2 FROM t1                                                                                 |
| 147 | root | localhost | test | Query   |   46 | Waiting for table flush         | FLUSH TABLES t2                                                                                      |
| 148 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1.e-20,'CC',-1.e+1)                                                           |
| 149 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | INSERT INTO t1 VALUES (-3,1e3,1.e+2)                                                                 |
| 150 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | DROP TABLE t1                                                                                        |
| 151 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | INSERT INTO t1 VALUES (1.e-3,'XYZ',3.1415927)                                                        |
| 152 | root | localhost | test | Query   |   47 | updating                        | DELETE FROM t2                                                                                       |
| 153 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | TRUNCATE t2                                                                                          |
| 154 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | UPDATE t3 SET c1='aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'                  |
| 155 | root | localhost | test | Query   |   48 | update                          | INSERT INTO t2 VALUES (1.e+2,10-10-2014,2990)                                                        |
| 156 | root | localhost | test | Query   |   47 | Waiting for table metadata lock | CREATE TABLE t1 (c1 CHAR(254) BINARY CHARACTER SET "latin1" COLLATE "latin1_bin",c2 REAL(40,30) ZERO |
| 157 | root | localhost | test | Query   |   46 | Waiting for table metadata lock | SELECT c1 FROM t1                                                                                    |
+-----+------+-----------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
151 rows in set (0.00 sec)
