Knowledgebase:
Install MyTOP on the VPS/Dedicated server
Posted by Ryan Mendonca on 30 September 2019 05:14:33 PM

Mytop is an open-source and free monitoring program for MySQL and MariaDB databases.

Mytop program provides a command-line shell interface to monitor real-time MySQL/MariaDB threads, queries per second, process list and performance of databases and gives an idea for the database administrator to better optimize the server to handle a heavy load.

Install Mytop on Cpanel is a simple task. You need to enable some Perl modules prior to the mytop installations.

---------------
/scripts/perlinstaller --force Getopt::Long
/scripts/perlinstaller --force DBI
/scripts/perlinstaller --force DBD::mysql
/scripts/perlinstaller --force Term::ReadKey
---------------

Then, run the following commands to install mytop on your cPanel server.

---------------
wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
tar xvf mytop-1.6.tar.gz
cd mytop-1.6/
perl Makefile.PL
make && make install
---------------

Once the installation completed, please create mytop configuration file for root.

---------------
vim /root/.mytop
---------------

and add the following to it.

---------------
user=root
pass=<your mysql password>
host=localhost
db=mysql
delay=5
port=3306
socket=
batchmode=0
header=1
color=1
idle=1
---------------

Please note that your MySQL root password can be found on the file /root/.my.cnf

That’s it !!!

(0 vote(s))
Helpful
Not helpful

Comments (0)