☰
✕
✕

How To Install Innotop in Linux

Monitoring Local and remote mysql server using Innotop

Innotop is an efficient command line monitoring tool for local and remote MySQL server 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



[root@linuxhelp Desktop]# yum install innotop
Loaded plugins: aliases, changelog, fastestmirror, kabi, presto, refresh-packagekit, security, tmprepo,verify
Loading support for CentOS kernel ABI
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.excellmedia.net
 * epel: epel.mirror.net.in
 * extras: mirror.nbrc.ac.in
 * remi: mirrors.thzhost.com
.
.
.
Installed:
  innotop.noarch 0:1.10.0-0.3.81da83f.el6                                                                              
Complete!.

To launch Innotop

Run innotop along with the user and password.

[root@linuxhelp Desktop]# innotop -u root -p ' redhat'


Now the terminal will be logged in.

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

Then you choose the option which you want to monitor or get the status information about the mysql.

Press " I" option to view the innodb I/O information' s

Press " B" option to view the innodb buffer information' s.

Press " R" option to view the innodb row operations, row operations misc, semaphore, Innodb array.

Press " S" option to view the innodb variable and status information.

Press " M" option to view the innodb replication status

Press " U" option to view the user statistic information

Press " O" option to open the tables status from your innodb.

Press ‘ C’ option to view the command summary information

< Ads2>

press " Q" option to view the query list.

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. After login into remote mysql server you can execute the same options what we executed in local mysql server.

[root@linuxhelp Desktop]# innotop -u root -p ' redhat'  -h localhost


Tag : Command Line Tools
FAQ
Q
How to Install innotop in linux?
A
Ensure that perl-TermReadKey package is installed.

Execute the following command:

yum install perl-TermReadKey
Q
What is innotop
A
innotop is a MySQL monitoring utility packed with advanced features for power users. It’s capable of showing different aspects of what’s going on in the server. It can monitor queries, replication, transactions, cache and many more.
Q
I try to install it from source in ubuntu it shows some depencies library file .is there any dependency . If there please provide it
A
the dependcies are libclass-d, libterm-readkey-perl
Q
how to install those dependencies ?
A
sudo apt-get install libclass-db sudo apt-get install libterm-readkey-perl
Q
is this command is like Top command
A
yes, but it shows only mysql details. It is mainly used for mysql