Monitor MySQL in real-time mode with mytop

mytop is one of the best real-time command line utilities to monitor MySQL. It is written by Jeremy Zawodny, and can be downloaded for free. It runs on most systems based on UNIX kernel, and Linux systems . This type of real-time monitoring is useful when managing a MySQL server.

You need a working MySQL server and some Perl modules like DBI, DBD :: mysql, Term :: ReadKey, and Getopt :: Long to be able to use mytop. You can download the source code of mytop here or get the binary package for your system. There are many packages for Fedora / Redhat and Ubuntu systems. You can find them easily on this site. Once you have the binary version of mytop, install it.

Once you've finished installing mytop, you can check if it's working by using the following command:

# mytop -h dbserver -u dbuser -p dbpassword

Monitor MySQL in real-time mode with mytop Picture 1

Replace dbserver , dbuser , and dbpassword with the correct names and passwords of your MySQL server.