Important Commandline Tools to Monitor MySQL Performance in Linux

Tools to monitor MySQL performance and troubleshoot a server

Mytop

Mytop is open source and free console-based (non-gui) monitoring tool for MySQL database Mytop runs in a terminal and displays statistics about threads, queries, slow queries, uptime, load, etc. in tabular format, which is much similar to the Linux top program.


Mtop

mtop (MySQL top) is a ohter open source, command line based real time MYSQL Server monitoring tool,

Innotop

Innotop is  advanced command line based monitoring program to monitor local and remote MySQL servers running InnoDB engine.

mysqladmin

mysqladmin is a inbuilt command line MySQL it helps such as monitoring processes, checking server configuration, reloading privileges, current status, setting root password, changing root password, create/drop databases, and much more.