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