Mysql Real-time Monitoring Tool

Similar to the linux top tool, mytop can monitor the performance information of mysql servers in real time.

Installation Method

1. Install Dependencies
Copy codeThe Code is as follows:
# Cpan
# Cpan> install DBI
# Cpan> install Term: ReadKey
# Cpan> install DBD: mysql
# Cpan> exit

2. Download and install mytop
Copy codeThe Code is as follows:
Cd/tmp
Wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
Tar xzf mytop-1.6.tar.gz
Cd mytop-1.6
Perl Makefile. PL
Make
Make install


Usage
Syntax:

Mytop-u <REMOTE_USERNAME>-p <PASSWORD>-h <MYSQL_SERVER_IP>-d <DATABASE>
REMOTE_USERNAME: mysql user name
PASSWORD: mysql PASSWORD
MYSQL_SERVER_IP: ip address of the mysql server
DATABASE: name of the DATABASE to be monitored
Example:

# Mytop-u root-p password-h 192.168.0.2-d centos
You can also write these parameters to a file ~ /. Mytop, in the following format:

User = Your mysql user
Pass = Your mysql password
Host = localhost
Db = Name of the database to be monitored
Delay = 5
Port = 3306
Socket =/var/lib/mysql. sock
Batchmode = 0
Header = 1
Color = 1
Idle = 1
For detailed instructions, Run man mytop.

Author: Zhu MahaI