How do I monitor what my MySQL server is doing?

To solve MySQL problems or to optimize MySQL server you need to use
special tool called mytop. It is a UNIX top command clone for MySQL
server. It updates every few seconds, so you can get a reasonable look
at your SQL performance. It is capable of displaying a huge amount of
information.

Please note that it needs Perl and other CPAN package to run. If you
are using Debian then just install it using apt-get command or Download
it from official web site:

read more