innotop
is an InnoDB transaction/status monitor. It is more advanced than mytop
as it knows how to monitor several kinds of things. Several modes exist, and they basically perform the following operations:
Replication and Galera cluster monitoring
Query monitoring
Transaction monitoring
The innotop
command works like the top
command and refreshes its data periodically. Here is an example:
> innotop When Load QPS Slow QCacheHit KCacheHit BpsIn BpsOut Now 0.00 254.85 0 19.00% 100.00% 35.10k 66.42k Total 0.00 89.87 3 42.63% 98.21% 14.41k 86.21k Cmd ID State User Host DB Time Query
You can monitor multiple servers at the same time. There are a lot of options and hotkeys. You can set a configuration file if you always want something specific or with a lot of servers to connect to.