Installing mytop on Linux
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
Similar Posts
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Comments
No comments yet.
Leave a comment