Innotop is a monitoring software for MySQL and InnoDB databases. It provides visibility and control over the ongoing activities within the server environment.
However, to enjoy innotop's excellent services, users must have some basic requirements, including Term::Readkey and Perl. Installing the software is pretty straightforward. Users can either opt to use their distribution package or install the tarball available. For those installing from the tarball, they would have to extract it and go into the resulting directory. They would then generate the makefile, which would check Perl module dependencies, and other requirements before finally installing the program and man page. The uninstallation process is as simple as running 'make uninstall.'
One of the significant advantages of innotop is that it continuously gets updated with new features and bug fixes. For instance, the latest stable release (1.4.3) received several exciting new features, including the addition of the standard -version option and column auto-completion when entering a filter expression. Moreover, the developers changed the color from blue to cyan, making it more visible on dark terminals. There was also some clarification of the username in password prompting and additional information to the filter-choosing dialog. They also fixed several bugs, including crashing when InnoDB status data was truncated, not displaying errors in tables with enabled debug, and others.
Furthermore, the innotop project's developers have released a newer development version: 1.5.1. They have added the C -Command Summary- mode to the latest version and fixed a bug in the'avg' aggregate function.
In summary, the innotop project is an excellent MySQL and InnoDB monitor software that has several features and benefits. Users must have some basic requirements before installation. The installation process is relatively easy, and users can choose to install from their distribution packages or the tarball. The developers continuously update the software to improve its functionality and remove bugs. The newer version includes the Command Summary mode and a bug fix in the 'avg' aggregate function.
Version 1.4.3 / 1.5.1: N/A