mysql> show full processlist;
+----+------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host            | db   | Command | Time | State                           | Info                                                                                                                                                             |
+----+------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|  1 | root | localhost:42052 | test | Sleep   | 2545 |                                 | NULL                                                                                                                                                             |
|  6 | root | localhost:42058 | test | Query   |   14 | Sending data                    | INSERT INTO `table1000_innodb_int_autoinc_not_null` ( `col_blob` ) SELECT `col_set` FROM `table1000_myisam_int_autoinc_not_null` WHERE `col_set` != 'b'  LIMIT 8 |
| 11 | root | localhost:42064 | test | Query   |   13 | Waiting for table metadata lock | ALTER TABLE `CC` DROP COLUMN c                                                                                                                                   |
| 17 | root | localhost:52206 | test | Query   |   15 | update                          | INSERT INTO `C` ( `p` ) VALUES ( 5 )                                                                                                                             |
| 27 | root | localhost:49946 | test | Query   |   15 | Waiting for table metadata lock | CREATE TABLE IF NOT EXISTS z (F1 INTEGER)                                                                                                                        |
| 32 | root | localhost:49980 | test | Query   |   14 | update                          | INSERT INTO `y` ( `F1` ) VALUES ( 'I' )                                                                                                                          |
| 37 | root | localhost:54447 | test | Query   |   13 | Waiting for table level lock    | INSERT INTO `table1000_myisam_int_autoinc_not_null` ( `pk` , `col_int_key` , `col_int`) VALUES ( NULL , 100 , 100 ) , ( NULL , 100 , 100 )                       |
| 39 | root | localhost:54479 | test | Query   |   -1 | NULL                            | show full processlist                                                                                                                                            |
| 43 | root | localhost:54495 | test | Query   |   13 | Waiting for table level lock    | SELECT LOAD_FILE('/randgen/randgen/data/earth81kb.jpg') , `col_int_key` FROM `table1000_myisam_int_autoinc_not_null` ORDER BY RAND() LIMIT 1                     |
| 48 | root | localhost:54547 | test | Query   |   15 | Updating                        | UPDATE `y` SET `F1` = CONVERT( 'rdrfhcvdfpychvtdgxqmzmkutfjjmkvpsjwixfsfdthlibhenjmtufroyvxmfib' USING UTF8 ) WHERE `F1` <= CONVERT( 'just' USING UCS2 )         |
| 53 | root | localhost:43261 | test | Query   |   13 | Waiting for table metadata lock | UPDATE r SET `pk` = 5 WHERE `col_int` = 0                                                                                                                        |
+----+------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
11 rows in set (0.00 sec)