Show the running queries

by rajesh 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..

Tagged in:

1363
like
0
dislike
0
mail
flag

You must LOGIN to add comments