実行中のプロセスを調べるには、SHOW PROCESSLISTコマンドを使用する事で調べれます。

mysql> SHOW PROCESSLIST;
+----+------+----------------+-------------+---------+------+-------+------------------+
| Id | User | Host           | db          | Command | Time | State | Info             |
+----+------+----------------+-------------+---------+------+-------+------------------+
|  2 | ODBC | localhost:1042 | NULL        | Sleep   | 6    |       | NULL             |
|  8 | root | localhost:2287 | db_customer | Query   | 0    | NULL  | SHOW PROCESSLIST |
+----+------+----------------+-------------+---------+------+-------+------------------+
2 rows in set (0.00 sec)