Show the running queries
by rajesh[ Edit ] 2007-08-14 17:26:36
In mysql we can look in to all the queries or list mysql processes that are currently being executed using
show processlist; query
Use command prompt to login to mysql query browser and then run the query
mysql> show processlist;
This will list the queries or processes like
+--------+-----------+-----------+-----------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-----------+-----------+-----------+---------+------+-------+------------------+
| 102538 | eximstats | localhost | eximstats | Sleep | 14 | | NULL |
| 102626 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+--------+-----------+-----------+-----------+---------+------+-------+------------------+
2 rows in set (0.01 sec)
Hope that helps..
