Locate Table Consuming High Resources

You need to install perl modules:-

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

after that, install mytop

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

mirror : wget http://notepad.harithdawi.com/files/mysql/mytop-1.6.tar.gz

execute below command (mydb is the database name)

mytop -u dba -p 'password' -h 10.2.4.5 -d mydb

• -u : Database username.


• -p : Database password.


• -h : Database server IP address.


• -d : Database name