Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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.