How to Install innotop on Ubuntu 16.04

Fetch 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

Launch Makefile.PL

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:

innotop

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!

Innotop running

 

 

 

Blog tags