GNU Info

(mysql.info)SHOW PROCESSLIST

---

Next: SHOW GRANTS Prev: SHOW LOGS Up: SHOW

---

Enter node , (file) or (file)node

`SHOW PROCESSLIST'
..................

`SHOW PROCESSLIST' shows you which threads are running.  You can also
get this information using the `mysqladmin processlist' command.  If
you have the *process* privilege, you can see all threads.  Otherwise,
you can see only your own threads.  Note: `KILL'.  If you don't
use the `FULL' option, then only the first 100 characters of each query
will be shown.

This command is very useful if you get the 'too many connections' error
message and want to find out what's going on. MySQL reserves one extra
connection for a client with the `Process_priv' privilege to ensure
that you should always be able to login and check the system (assuming
you are not giving this privilege to all your users).