How to Install innotop in linux?

Innotop is an efficient command-line monitoring tool for local and remote MySQL servers running under Innodb. It helps to monitoring several operations like MySQL replication status, user statistics, query list, InnoDB buffers, InnoDB I/O information etc.

To Install Innotop

Run the following command to install Innotop

In RedHat

yum install innotop

In Ubuntu

Fetch innotop from its GIT repository:

Install Perl dependency:

sudo apt install libterm-readkey-perl libclass-dbi-perl libclass-dbi-mysql-perl make 

sudo apt-get install git

git clone https://github.com/innotop/innotop.git

Or 

wget https://github.com/innotop/innotop/archive/refs/heads/master.zip

cd innotop/

perl Makefile.PL

Note: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 make install

Innotop can be launched in several ways, the easiest is to provide, on the command line, username and password (with -u [user] and -p [password]) of a privileged user.

Syntax:

sudo innotop -uuser -ppassword

Now the terminal will be logged in.

Press " ?" help symbol to view the various option available.

To Monitor the remote mysql server

If you want to monitor the remote mysql server, run the below command. Login the remote mysql server enter the mysql username, password and hostname.

sudo innotop -uuser -ppassword -hip_address