Monitoring MySQL server has never been an easy task. Monitoring also needs to go through many Complex and difficult queries to get the details.
All these problems can be overcome by an excellent command line monitoring tool called “Innotop”. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects of MySQL (InnoDB) performance and also helps database administrator to find out what’s wrong going with MySQL server. Innotop helps in monitoring user statistics, mysql replication status,query list, InnoDB I/O informations etc. Another important thing about innotop is it refreshes the data continuously , so we can view realtime statistics.
Innotop is one of the designed based on top utility for linux.…[Read more]