Ever wondered “what the hell is that mysql server doing”? Search no longer, My top is the answer. Mytop is a clone of top, a utility every sysadmin knows about, but instead of monitoring the system, it follows MySQL threads. In a nutshell, it’s a nifty command line tool that will connect to a MySql server and periodically run the
SHOW PROCESSLIST and
SHOW STATUS commands. It will then provide nice summaries of the results, and let the user apply various filters.
After the installation you can run mytop providing some parameters, for example: mytop -u root -p rootpass -d database, where database is the database you want to monitor, or you may create a .mytop file containing the configuration directives so you don’t have to type everything every time.