innotop
Install
yum install innotop
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
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
Bibliography
https://github.com/innotop/innotophttps://www.tecmint.com/install-innotop-to-monitor-mysql-server-performance/https://github.com/innotop/innotophttps://lefred.be/content/innotop-for-mysql-8-0/https://www.percona.com/blog/2013/10/14/innotop-real-time-advanced-investigation-tool-mysql/https://helpmanual.io/man1/innotop/http://www.linux-commands-examples.com/innotop