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