How can I monitor MySQL via SSH?
You can monitor mySQL through ssh with the mytop program which displays MySQL server performance info like top. Mytop will connect to a MySQL server and periodically run the SHOW PROCESSLIST and SHOW STATUS commands and attempt to summarize the information from them in a useful format.
To run the mytop program simply log into your server as the root user and type “mytop”. More information about mytop is located at the URL below.
http://jeremy.zawodny.com/mysql/mytop/
About Author
