innotop

innotop project is a MySQL and InnoDB monitor that lets you view and manage what's happening inside your MySQL servers.

Features include a top-like query list, a top-like InnoDB transaction list, and much more. This tool gives you a high level of insight into the inner workings of InnoDB.

Requirements:

· Term::Readkey
· Perl

Installation:

Installing innotop is pretty easy. Either use your distribution's package, or install from a tarball. If you install from the tarball, extract the tarball and go into the resulting directory:

tar zxvf innotop-< version >.tar.gz
cd innotop-< version >

Generate the makefile, which will check Perl module dependencies and so forth:

perl Makefile.PL

Install the program and man page:

make install

To remove the files, simply run:

make uninstall

What's New in 1.4.3 Stable Release:

Changes:
· Added standard --version command-line option
· Changed colors to cyan instead of blue; more visible on dark terminals.
· Added information to the filter-choosing dialog.
· Added column auto-completion when entering a filter expression.
· Changed Term::ReadKey from optional to mandatory.
· Clarified username in password prompting.
· Ten thousand words of documentation!

Bugs fixed:
· innotop crashed in W mode when InnoDB status data was truncated.
· innotop didn't display errors in tables if debug was enabled.
· The colored() subroutine wasn't being created in non-interactive mode.
· Don't prompt to save password except the first time.

What's New in 1.5.1 Development Release:

· Added C (Command Summary) mode.
· Fixed a bug in the 'avg' aggregate function.