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.
When loaded, press d to prompt for a specific database name to monitor.