Innotop is an excellent command line program, similar to ‘top command‘ to monitor local and remote MySQL servers running under InnoDB engine. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects of MySQL performance and also helps database administrator to find out what’s wrong going with MySQL server.
For example, Innotop helps in monitoring mysql replication status, user statistics, query list, InnoDB buffers, InnoDB I/O information, open tables, lock tables, etc, it refreshes its data regularly, so you could see updated results.
Innotop MySQL Server Monitoring
Innotop comes with great features and flexibility and doesn’t needs any extra configuration and it can be executed by just running ‘innotop‘ command from the terminal.
Installing Innotop (MySQL Monitoring)
By default innotop package is not included in Linux distributions such as RHEL, CentOS, Fedora and Scientific Linux. You need to install it by enabling third party epel repository and using yum command as shown below.
No comments:
Post a Comment