mysql> show processlist;
+----+--------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User   | Host      | db     | Command | Time | State                | Info                                                                                                 |
+----+--------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
|  7 | drupal | localhost | drupal | Query   |   79 | Copying to tmp table | SELECT COUNT(path) AS hits, path, title, AVG(timer) AS average_time, SUM(timer) AS total_time FROM a |
|  9 | root   | localhost | NULL   | Query   |    0 | NULL                 | show processlist                                                                                     |
+----+--------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
2 rows in set (0.02 sec)