Archive for the tag 'Mytop'

SBDavid
Jun 8th, 2009

How to install Mytop in Plesk servers

How to install Mytop in Plesk servers

Mytop is a Perl program which allows to monitor MySQL servers by viewing active threads, queries and overall server performance numbers.

mytop is a `top’ clone for MySQL

mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL 3.22.x, 3.23.x, and 4.x servers. It runs on most Unix systems which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. As of version 0.7, it even runs on Windows (somewhat).

INSTALLATION

tar -zxvf mytop-.tar.gz
cd mytop-
perl Makefile.PL
make
make test
make install

Now installation is over. If you run mytop command, it won’t work in Plesk servers. You need to make some configurations in “~/.mytop” file. Create a file called ~/.mytop and add the below entries in “~/.mytop” file.

$ touch ~/.mytop
$ vi ~/.mytop

user=admin
pass=your mysql password
host=localhost
db=psa
delay=5
port=3306
socket=
batchmode=0
header=1
color=1
idle=1

Run the mytop command

$ mytop -u admin -p(Your Mysql password)

Now you can see the overall performance of your MySQL server.