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
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.
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.
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.
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.