How to use mytop Real-time Monitoring tool in mysql
This article introduces how to use mytop real-time monitoring tool in mysql, the content is very detailed, interested friends can refer to, hope to be helpful to you.
Mytop is similar to the linux top tool in that it can monitor the performance information of mysql servers in real time.
Installation method
1. Installation dependency
# cpan
# cpan > install DBI
# cpan > install Term::ReadKey
# cpan > install DBD::mysql
# cpan > exit
2. 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
Usage
Syntax:
Www.2cto.com
Mytop-u-p-h-d
REMOTE_USERNAME:mysql user name
PASSWORD: mysql password
MYSQL_SERVER_IP: mysql server ip
DATABASE: the name to be monitored
Example:
# mytop-u root-p password-h 192.168.0.2-d centos
You can also write these parameters to the file ~ / .mytop in the following format:
User= your 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
On how to use mytop real-time monitoring tools in mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.
