If you need to monitor MySQL and want to see the database used at that particular time, as well as the state and time you can use the following command to check it:

root@server# mysqladmin processlist

Or

root@server# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 121572 to server version: 4.1.22-standard

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> SHOW FULL PROCESSLIST;

That’s it!

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.