Innotop: Powerful MySQL monitoring command line tool

Innotop is an excellent command line program, similar to the top command, used to monitor local and remote MySQL servers running under the InnoDB engine. It provides a comprehensive set of features and options to help database administrators (DBAs) track various aspects of MySQL performance, troubleshoot issues and optimize server configuration.

Innotop allows you to monitor critical MySQL metrics, such as:

• MySQL replication status
• User statistics
• Query list
• InnoDB buffer pool
• InnoDB I/O Statistics
• Open table
• Locked table
• etc…

The tool regularly refreshes its data, providing real-time insight into server status.

Install Innotop (MySQL Monitoring Tool) in Linux

Innotop is found in the package manager for most Linux distributions, and you can install it according to your distribution using the following command:

 <code>sudo apt install innotop [在**Debian、Ubuntu和Mint** 上] sudo yum install innotop [在**RHEL/CentOS/Fedora** 和**Rocky/AlmaLinux** 上] sudo emerge -a sys-apps/innotop [在**Gentoo Linux** 上] sudo apk add innotop [在**Alpine Linux** 上] sudo pacman -S innotop [在**Arch Linux** 上] sudo zypper install innotop [在**OpenSUSE** 上] sudo pkg install innotop [在FreeBSD上]</code>

If your distribution's package repository does not have Innotop in your distribution's package repository, you can clone the GitHub repository and install it manually:

 <code>git clone https://github.com/innotop/innotop.git cd innotop</code>

Next, you need to install some Perl dependencies using CPAN or cpanminus. If you don't have cpanminus installed, you can install it using your package manager:

 <code>sudo apt install cpanminus [在**Debian、Ubuntu和Mint** 上] sudo yum install cpanminus [在**RHEL/CentOS/Fedora** 和**Rocky/AlmaLinux** 上] sudo emerge -a sys-apps/cpanminus [在**Gentoo Linux** 上] sudo apk add cpanminus [在**Alpine Linux** 上] sudo pacman -S cpanminus [在**Arch Linux** 上] sudo zypper install cpanminus [在**OpenSUSE** 上] sudo pkg install cpanminus [在FreeBSD上]</code>

Then, use cpanminus to install the required Perl module.

 <code>cpanm Term::ReadKey DBI DBD::mysql</code>

After installing the dependencies, you can run Innotop by executing the following command.

 <code>perl innotop</code>

Or, if you have installed Innotop through cpanminus, you can start it directly.

 <code>innotop</code>

Monitor MySQL performance using Innotop

After Innotop is running, you can use the following command to specify the username and password to connect to your MySQL server:

 <code>innotop -u root -p 'your_password'</code>

Once connected to the MySQL server, you will see a dashboard similar to the following:

Press the ? key to view a summary of command line options and usage.

Innotop mode

You can switch between different modes by pressing the corresponding key:

Query list

Shows the output of SHOW FULL PROCESSLIST , similar to the query list pattern in mytop. It does not display InnoDB-specific information, but is useful for general query monitoring.

InnoDB I/O Information

Displays I/O statistics for InnoDB, including suspended I/O, I/O threads, file I/O and log statistics.

InnoDB buffer pool

Displays information about InnoDB buffer pools, page statistics, insert buffers, and adaptive hash indexes.

InnoDB line operation

Displays InnoDB line operations, including insertion, update, read, and delete.

Command summary

Displays a summary of commands executed on the MySQL server, including the number of times each command was executed.

Variables and states

Displays various server variables and status information, such as queries per second, connections, and cache usage.

Summarize

Innotop is a powerful MySQL monitoring tool that provides real-time insight into all aspects of MySQL performance. With its easy-to-use command-line interface, it helps DBA identify problems, optimize queries, and monitor the health of MySQL servers.

Whether you are managing a single server or multiple MySQL instances, Innotop provides an efficient way to track performance metrics and ensure database operations go smoothly.

The above is the detailed content of Innotop - A CLI Based top-like Monitor Tool for MySQL. For more information, please follow other related articles on the PHP Chinese website!