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 InnotopRun the following command to install InnotopIn RedHatyum install innotopIn UbuntuFetch 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 gitgit clone https://github.com/innotop/innotop.gitOr wget https://github.com/innotop/innotop/archive/refs/heads/master.zipcd innotop/perl Makefile.PLNote: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 installInnotop 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 -ppasswordNow the terminal will be logged in.Press ” ?” help symbol to view the various option available.To Monitor the remote mysql serverIf 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

- A word from our sposor -

How to Install innotop in linux?