I was reading High Perfomance Mysql and in that book they mention a tool called Mytop basically it is a top clone for Mysql. Instead of running show full processlist; repetedly on the mysql console just run mytop. Helps you quite a bit.

I had an installing it. I get the foll error

Can’t locate Term/ReadKey.pm in @INC (@INC contains: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i386-linux

This is because it requires TermReadKey Perl Package. Just run

yum install perl-TermReadKey

and you are ready to go.