Monday, January 12, 2009

MySQL: Find Out Which Table is Consuming Resources

You can use mytop command a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL.
Install Mytop:
First install required perl modules:
cpan -i Term::ReadKey
cpan -i Term::ANSIColor
cpan -i Time::HiRes

Next, install mytop, enter:
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

To view information about database called foo, enter:
$ mytop -u dba -p 'password' -h 10.2.4.5 -d foo

Where,

* -u : Database username.
* -p : Database password.
* -h : Database server IP address.
* -d : Database name.

Read mytop man page for further information:
perldoc mytop

ANL

No comments: