innotop

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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.188.91.44