In this tutorial we will show you how to install and configuration of Mtop (MySQL Database Server Monitoring) on your CentOS 6 server. For those of you who didn’t know, Mtop is an open source real time MySQL Server monitoring program that shows queries which are taking longer time to process and kills those longer queries after certain number of specified time. Mtop program enable us to monitor and identify performance and related issues of MySQL Server from the command line interface similar to Linux Top Command.
This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation Mtop on CentOS 6.
Install Mtop (MySQL Database Server Monitoring) on CentOS 6
Step 1. First, you need to enable RPMForge repository under your Linux machine to download and install latest version of MTOP program.
1 2 3 4 5 6 7 8 9 | ## RHEL/CentOS 6 32-Bit ## wgethttp://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpm rpm-Uvhrpmforge-release-0.5.2-2.el6.rf.i686.rpm ## RHEL/CentOS 6 64-Bit ## wgethttp://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm rpm-Uvhrpmforge-release-0.5.2-2.el6.rf.x86_64.rpm |
1 | yuminstallmtop |
To start Mtop program, you need to connect to your MySQL Server, using following command:
1 2 3 4 5 6 7 8 9 10 11 12 13 | # mysql -u root -p mysql>grantsuper,reload,processon *.*tomysqltop; QueryOK,0rowsaffected(0.00sec) mysql>grantsuper,reload,processon *.*tomysqltop@localhost; QueryOK,0rowsaffected(0.00sec) mysql>flushprivileges; QueryOK,0rowsaffected(0.00sec) mysql>quit; Bye |
1 | mtop |
Mtop usage and functions keys:
1 2 3 4 5 6 7 8 9 10 | s–changethenumberofsecondstodelaybetweenupdates m–togglemanualrefreshmodeon/off d–filterdisplaywithregularexpression(user/host/db/command/state/info) F–fold/unfoldcolumnnamesinselectstatementdisplay h–displayprocessforonlyonehost u–displayprocessforonlyoneuser i–toggleall/non-Sleepingprocessdisplay o–reversethesortorder q–quit ?–hel |
Congratulation’s! You have successfully installed Mtop. Thanks for using this tutorial for installing Mtop (MySQL Database Server Monitoring) on CentOS 6 system. For additional help or useful information, we recommend you to check the official Mtop web site.
