Mysql - Installing mytop on Linux

Home > Mysql > Installing mytop on Linux

Installing mytop on Linux

October 15th, 2007 Hitesh Agrawal Leave a comment Go to comments

mytop is a clone of “TOP” command frequently used by Linux Administrator to check the Average Load on the Linux Machine. But mytop checks the Load of the various threads running on the MySql Database.

Other Software Requirements:
PERL
ReadKey

To Install mytop following steps needs to be followed

Download the latest mytop tar.gz File from “http://jeremy.zawodny.com/mysql/mytop/” website
On the linux console follow the following Steps to install MyTop
tar -zxvf mytop-version.tar.gz
cd mytop-version
perl Makefile.PL
make
make test
make install
Be careful while installing as you might get errors while Making the file related to ReadKey i.e. readkey version was not installed. To resolve this problem you will have to install the latest version of the ReadKey located at ReadKey Download Link
Installation Steps for ReadKey:
Unpack the tar file
perl Makefile.PL
make test
If the compilation and the tests are successful, then type “make install”
After Installing the ReadKey Package again try to make the file and now the mytop package will get installed without any problem

Using mytop:
You can directly use the mytop by typing “mytop” on your console screen initially you will get a message that “Unable to connect to Mysql” you will need to provide the host name, database name, username, password.

To connect to the MySql database using Mytop you will need to give all your MySql details as a parameter:

-u – username of the database
-p – password for connecting to the database
-d – database name
-h – Host Name

Example:
mytop -u root -p password -h localhost -d test

For more details on the documentation and parameters refers to the MyTop Documentation Online: http://jeremy.zawodny.com/mysql/mytop/mytop.html