Mtop

página do projeto

• http://mtop.sourceforge.net/

instalando em Debian 8

apt-get install libncurses5-dev libcurses-perl libgetopt-simple-perl \
libnet-domain-tld-perl libdbi-perl libdbd-mysql-perl make
cd /usr/src/
wget http://ufpr.dl.sourceforge.net/project/mtop/mtop/v0.6.6/mtop-0.6.6.tar.gz
tar xzf mtop-0.6.6.tar.gz
cd mtop-0.6.6/
perl Makefile.PL
make
make install

acesso direto o mysql

grant super, reload, process on *.* to mysqltop;
grant super, reload, process on *.* to mysqltop@localhost;
flush privileges;

run

roda com atualização a cada 1 segundo

mtop -se 1

Referência

• http://www.shkodenko.com/mtop-utility-installation-on-debian-7/