Mytop is a MySQL monitoring tool similar to the top command style in Linux. It can monitor the current connected user and the commands being executed.
Mytop is a MySQL monitoring tool similar to the top command style in Linux. It can monitor the current connected user and the commands being executed.
Similar to the linux top tool, mytop can monitor the performance information of mysql servers in real time.
Installation Method
1. Install Dependencies
The Code is as follows:
# Cpan
# Cpan> install DBI
# Cpan> install Term: ReadKey
# Cpan> install DBD: mysql
# Cpan> exit
2. Download and install mytop
The 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 -P -H -D
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
