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)