How to Install innotop on Ubuntu 16.04
innotop from its GIT repository:
sudo apt-get install git git clone https://github.com/innotop/innotop.git
Install any missing Perl dependency:
sudo apt-get install libclass-dbi-mysql-perl sudo apt-get install libterm-readkey-perl
cd innotop/ perl Makefile.PL
If there no warnings and errors (in case you have to fix other dependencies), proceed with the installation of this good MySQL InnoDB real time monitor:
sudo apt-get install make sudo make install
Innotop is now installed and can be launched through the command:
To authenticate into MySQL/MariaDB, you can pass the credentials in several ways, the easiest is to provide, on the command line, username and password (with
-u [user] and
-p [password]) of a privileged MySQL/MariaDB user.
As always you have to consider that, using the command line to authenticate, leaves secrets in your terminal history - not mentioning in the running process details - authenticate using the password in the command line only when running locally and not on a shared or production MySQL/MariaDB server!