Innotop MySQL Monitoring Tool

Innotop MySQL Monitoring Tool

Innotop is a monitoring tool that displays MySQL and InnoDB Storage engines in text mode. Innotop is developed in the perl language. It can be used more flexibly on various operating platforms. It can monitor the running status of the current mysql and innodb Storage engines in detail, the maintenance personnel can optimize the database based on the results to make the database run more stably and efficiently. innotop relies on the perl-ExtUtils-MakeMaker software package of the system.

1. Install the perl dependency package

[Root @ bkjia ~] # Yum install perl-ExtUtils-MakeMaker
[Root @ bkjia ~] # Rpm-aq | grep perl-ExtUtils-MakeMaker
Perl-ExtUtils-MakeMaker-6.55-136.el6_6.1.x86_64
[Root @ bkjia ~] #

2. download and install the innotop Monitoring Tool
[Root @ bkjia ~] # Wget http://innotop.googlecode.com/files/innotop-1.9.0.tar.gz
[Root @ bkjia ~] # Tar xvf innotop-1.9.0.tar.gz-C/usr/local/
[Root @ bkjia ~] # Cd/usr/local/innotop-1.9.0/
[Root @ bkjia innotop-1.9.0] # perl Makefile. PL
Checking if your kit is complete...
Looks good
Writing Makefile for innotop

[Root @ bkjia 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
[Root @ bkjia innotop-1.9.0] # echo $?
0
[Root @ bkjia innotop-1.9.0] #
 
3. innotop help and monitoring instances
[Root @ bkjia 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'
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 slave servers at once with innotop.

[Root @ bkjia innotop-1.9.0] #./innotop-u root-psystem-h localhost-S/tmp/mysql. sock
[RO] Dashboard (? For help) -- input? Or htlp to view help information
Uptime MaxSQL ReplLag Cxns Lock QPS Run t1_repl SQL

6d 1 0 0.40 ^ _____ 551 Off

Input? Number to view help information
Switch to a different mode:
A Dashboard I InnoDB I/O Info Q Query List
B InnoDB Buffers K InnoDB Lock Waits R InnoDB Row Ops
C Command Summary L Locks S Variables & Status
D InnoDB Deadlocks M Replication Status T InnoDB Txns
F InnoDB FK Err O Open Tables U User Statistics

Actions:
D Change refresh interval p Pause innotop
K Kill a query's connection q Quit innotop
N Switch to the next connection x Kill a query

Other:
TAB Switch to the next server group/Quickly filter what you see
! Show license and warranty = Toggle aggregation
# Select/create server groups @ Select/create server connections
$ Edit configuration settings \ Clear quick-filters
Press any key to continue

This article permanently updates the link address: