gistfile1.txt

mysql> show processlist;
+----+------+-----------+-------+---------+------+-------------------------+-----------------------------+
| Id | User | Host      | db    | Command | Time | State                   | Info                        |
+----+------+-----------+-------+---------+------+-------------------------+-----------------------------+
|  2 | root | localhost | mysql | Query   |    0 | starting                | show processlist            |
|  3 | root | localhost | NULL  | Query   |   13 | Waiting for table flush | FLUSH TABLES WITH READ LOCK |
|  4 | root | localhost | mysql | Query   |    4 | Waiting for table flush | SELECT * FROM user          |
+----+------+-----------+-------+---------+------+-------------------------+-----------------------------+
3 rows in set (0.00 sec)