Innotop of MySQL monitoring tools

Innotop is a monitoring tool that displays MySQL and InnoDB storage engines through text mode. Innotop is developed in the Perl language, which is more flexible to use on a variety of operating platforms, it can monitor the current MySQL and InnoDB storage engine running state, so that maintenance personnel based on the results of reasonable optimization of the database, Let the database run more stably and efficiently. Innotop relies on the system's Perl-extutils-makemaker package.

1. Installing Perl Dependency Packages

[email protected] ~]# Yum install Perl-extutils-makemaker

[Email protected] ~]# Rpm-aq | grep perl-extutils-makemaker
Perl-extutils-makemaker-6.55-136.el6_6.1.x86_64
[Email protected] ~]#

2. Download and install the INNOTOP monitoring tool

[email protected] ~]# wget http://innotop.googlecode.com/files/innotop-1.9.0.tar.gz

[Email protected] ~]# tar xvf innotop-1.9.0.tar.gz-c/usr/local/

[Email protected] ~]# cd/usr/local/innotop-1.9.0/
[Email protected] innotop-1.9.0]# Perl makefile.pl

[[email protected] innotop-1.9.0]# make install
CP Innotop Blib/script/innotop
/usr/bin/perl-mextutils::my-e ' My->fixin (Shift) '--blib/script/innotop
Manifying BLIB/MAN1/INNOTOP.1
Installing/usr/local/share/man/man1/innotop.1
Installing/usr/local/bin/innotop
Appending installation Info To/usr/lib64/perl5/perllocal.pod
[[email protected] innotop-1.9.0]# echo $?
0
[Email protected] innotop-1.9.0]#

3.innotop using Help and monitoring instances

[Email protected] innotop-1.9.0]#/innotop--help
Usage:innotop <options> <innodb-status-file>

--[no]color-c use terminal coloring (default)
--config-c config file to read
--count number of updates before exiting
--delay-d delay between updates in seconds
--help Show This Help message
--host-h Connect to host
--[no]inc-i Measure Incremental Differences
--mode-m Operating mode to start in
--nonint-n non-interactive, Output tab-separated fields
--password-p password to use for connection
--port-p port number to use for connection
--skipcentral-s Skip Reading the central configuration file
--socket-s MySQL socket to use for connection
--spark Length of Status Sparkline (default 10)
--timestamp-t Print timestamp in-n mode (1:per iter; 2:per line)
--user-u user for Login if not current user
--version Output version information and exit
--write-w write running configuration into home directory if no config files were loaded

Innotop is a MySQL and InnoDB transaction/status Monitor, like ' top ' for
Mysql. IT displays queries, InnoDB transactions, lock waits, deadlocks,
Foreign key errors, open tables, replication status, buffer information,
Row operations, logs, I/O operations, load graph, and more. You can
Monitor many servers at once with Innotop.

[Email protected] innotop-1.9.0]#/innotop-u root-psystem-h localhost-s/tmp/mysql.sock

[RO] Dashboard (? For help) Localho St, 8d, 0.00 QPS, 1/1/0 CON/RUN/CAC Thds, 5.7.4-m14-log

Uptime maxsql repllag cxns Lock QPS QPS Run Run TBLs Repl SQL
8d 1 0 0.00 104 Off

This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1620134

Innotop of MySQL monitoring tools