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!
