Find Out Which Table is Consuming Resources using Mytop

Step 1 : Install required perl modules

cpan -i Term::ReadKey
cpan -i Term::ANSIColor
cpan -i Time::HiRes


Step 2 :  Install mytop in your system

#wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz

# tar -zxvf mytop-1.6.tar.gz

#cd mytop-1.6

#perl Makefile.PL

#make

#make test

#make install


Step 3 : To view information of database example run below command.

# mytop -u username -p 'password' -h Hostname -d example