mytop USES the introduction mysql real time monitoring tool
- 2020-05-13 03:35:27
- OfStack
Similar to the linux top tool, mytop can monitor the performance of mysql servers in real time.
Installation method
1. Installation dependencies
2. Download and install mytop
Method of use
Grammar:
mytop -u < REMOTE_USERNAME > -p < PASSWORD > -h < MYSQL_SERVER_IP > -d < DATABASE >
REMOTE_USERNAME: mysql username
PASSWORD: mysql password
MYSQL_SERVER_IP :mysql server ip
DATABASE: name of the database to monitor
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 users
pass= your mysql password
host=localhost
db= the name of the database you want to monitor
delay=5
port=3306
socket=/var/lib/mysql/mysql.sock
batchmode=0
header=1
color=1
idle=1
Detailed instructions for use can be obtained by performing man mytop.
By zhu maohai
Installation method
1. Installation dependencies
# cpan
# cpan > install DBI
# cpan > install Term::ReadKey
# cpan > install DBD::mysql
# cpan > exit
2. Download and install mytop
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
Method of use
Grammar:
mytop -u < REMOTE_USERNAME > -p < PASSWORD > -h < MYSQL_SERVER_IP > -d < DATABASE >
REMOTE_USERNAME: mysql username
PASSWORD: mysql password
MYSQL_SERVER_IP :mysql server ip
DATABASE: name of the database to monitor
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 users
pass= your mysql password
host=localhost
db= the name of the database you want to monitor
delay=5
port=3306
socket=/var/lib/mysql/mysql.sock
batchmode=0
header=1
color=1
idle=1
Detailed instructions for use can be obtained by performing man mytop.
By zhu maohai