Mayur's BLOG

# Download mytop

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

# Extract and change directory

tar -zxvf mytop-1.6.tar.gz
cd mytop-1.6

# Install mytop

perl Makefile.PL
make
make install

How do I use mytop command?

mytop command needs username and password to access MySQL server. For example if your username is admin and password is 123456 then you can start mytop as follows:

$ mytop -u admin -p 123456

database (phpbb) to monitor:

$ mytop -u admin -p 123456 -d phpbb

You can store this information in ~/.mytop file:

vi ~/.mytop

Add config text as follows:

user=admin
pass=123456
host=mysql0.hosting.some.com
db=imail
delay=10
port=3306
socket=
batchmode=0
header=1
color=1
idle=1

mytop is capable of displaying a large amount of information and it supports lots of keyboard shortcut too, so be sure to read the man page and documentation of mtop.

++++++++++
If you need any assistance, We can provide you for a small fee. please email us mayur24.c@gmail.com
++++++++++