MySQL and InnoDB expose lots of information about their internals, but it’s hard to understand and monitor much of it. To solve this problem I wrote innotop, a text-mode MySQL and InnoDB monitoring tool. It has lots of features, is fast and configurable, and it’s easy to use. It is inspired by the venerable mytop, but is much more powerful.
Why another text-mode monitoring tool?
Because the available ones aren’t good enough. I didn’t want to duplicate anyone else’s effort, but existing tools haven’t been actively maintained in years, don’t work correctly with newer versions of MySQL, and only offer a small fraction of the features I’ve built into innotop.
Features
innotop can monitor InnoDB transactions and internals, queries and processes, deadlocks, foreign key errors, replication status, system variables and status and much more.