Mysql Real-time Monitoring Tool mytop usage

The mysql Real-time Monitoring Tool mytop is similar to the linux top tool. It can monitor the performance information of mysql servers in real time. Installation Method
1. install dependency # cpan> install DBI # cpan> install Term: ReadKey # cpan> install DBD: mysql # cpan> exit
2. Download and install mytop cd/tmpwget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gztar xzf mytop-1.6.tar.gzcd mytop-1.6perl Makefile. PLmakemake install usage Syntax: www.2cto.com mytop-u <REMOTE_USERNAME>-p <PASSWORD>-h <MYSQL_SERVER_IP>-d <DATABASE> REMOTE_USERNAME: mysql Username PASSWORD: mysql PASSWORD MYSQL_SERVER_IP: mysql Server ipDATABASE: Example of the name of the database to be monitored: # mytop-u root-p password-h 192.168.0.2-d centos can also write these parameters to the file ~ /. Mytop, in the following format: user = Your mysql user pass = Your mysql password host = localhostdb = the name of the database you want to monitor delay = 5 port = 3306 socket =/var/lib/mysql. sockbatchmode = 0 header = 1 color = 1 idle = 1 detailed instructions can be obtained by running man mytop. Author: Zhu MahaI