innotop For Linux

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

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.