Monitor MySQL Performance with mytop

By | 2013/01/10

mytop is an excellent app to monitor mysql performance. Let’s check it out!


Firstly, install mytop:

$ sudo apt-get install mytop

Run mytop with tack tack prompt to have mytop prompt for the root mysql password:

$ mytop --prompt


Done! You can now monitor the number of mysql queries the server is processing as well as key buffer efficiency.

mytop

When loaded, press d to prompt for a specific database name to monitor.

mytop_02

Leave a Reply

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail. You can also subscribe without commenting.