innotop

Install

For Red Hat derivatives (RHEL, OEL, CentOS etc) ensure EPEL repository is enabled.

yum install innotop

innotop has dependencies on perl-TermReadKey and perl-Time-HiRes

Usage

To connect as 'root', prompt for the password, using the socket file in /mysql/data/mysql.sock with a 1 second refresh rate...

innotop -u root --askpass --socket /mysql/data/mysql.sock --delay 1

  • The default socket is: /var/lib/mysql/mysql.sock

  • The default delay is: 10 seconds

You can change this when innotop is running by pressing "d"

When innotop is running hit "?" for help

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:

a Toggle the innotop process k Kill a query's connection

c Choose visible columns n Switch to the next connection

d Change refresh interval p Pause innotop

e Explain a thread's query q Quit innotop

f Show a thread's full query r Reverse sort order

h Toggle the header on and off s Change the display's sort column

i Toggle idle processes 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