See what is running on your mysql | See running queries and processes | find stuck process
Published by Nicholas Dunbar on February 19th, 2013
Run the following query against your database:
show full processlist;
To which you will get something like the following:
+--------+--------+-----------+--------+---------+------+----------------------+---------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+--------+-----------+--------+---------+------+----------------------+---------------------------------------------------------------+ | 708163 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 708174 | test | localhost | test | Query | 2 | Copying to tmp table | select dist.name, dist.filename, count(*) from orders_header | +--------+--------+-----------+--------+---------+------+----------------------+---------------------------------------------------------------+ 2 rows in set (0.00 sec)
source: http://www.electrictoolbox.com/show-running-queries-mysql/
Posted on February 19th, 2013