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.

Tags: ,

One Response to “How to install Mytop in Plesk servers”

  1. # 2frankensteinon 08 Jan 2022 at 3:56 pm

    2wounding…

    …

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.