Linux

Commandline Tools To Monitor MySQL Performance In Linux

Commandline Tools To Monitor MySQL Performance In Linux

Insight: Useful Commandline Tools To Monitor MySQL Performance In Linux

There are so many tools available these days to monitor MySQL performance in Linux operating system. Out of many we thought to list out some of the useful and effective command line tools to monitor MySQL performance in Linux.

Useful Commandline Tools to Monitor MySQL Performance in Linux

1. Mtop

Mtop or MySQL top is an open source and command line based  MYSQL Server monitoring tool. It is a real time monitoring tool which was written in Perl. It can display real time MySQL server queries and also provides MySQL configuration information.

 

Install Mtop

2. Mytop

Mytop is an open source and command line MYSQL monitoring tool. Mytop display MySQL server performance info like ‘top’ command in Linux. Mytop  can monitor (in real-time) MySQL threads, queries, and uptime as well as see which user is running queries on which database, which are the slow queries, and more.

Install Mytop

3. Innotop

Innotop is an another real time and command line based monitoring tool to monitor local and remote MySQL servers running under InnoDB engine. It is also similar to the ‘top’ command. It  can monitors many servers at once and can aggregate across them.

Install Innotop

4. mysqladmin

mysqladmin is a default command line MySQL client. It comes pre-installed with MySQL package. It is basically used to monitor processes, reloading privileges, current status, setting root password, changing root password, create/drop databases, and much more.

 



READ THIS ALSO  Limit CPU Usage Of A Process In Linux