Mtop (MySQL Monitoring Tool)<\/p>\n
mtop screen<\/p>\n
Mtop is a little perl utility that shows in real time statistics of your MySQL server. It allows you to quickly identify problems related to mysql poor performance, using an interface similar to the normal \u2018top\u2019 command.<\/p>\n
If you are using Debian then the installation is trivial as mtop is in the debian packages and the installation is as simple as:<\/p>\n
aptitude install mtop<\/p>\n
This will install all the required dependencies and once it completes you are ready to go. Just type mtop on the command prompt.<\/p>\n
To install mtop on RHEL I needed to first satisfy a dependency (perl-Curses) that is not available in the regular RHEL packages. The quickest way to install perl-Curses is to use a build rpm that can be found for example:
\nhttp:\/\/dag.wieers.com\/packages\/perl-Curses\/
\nDepending from your RHEL version download the respective package, perl-Curses-1.13-1.1.el3.rf.i386.rpm for RHEL3 i386, or perl-Curses-1.13-1.2.el4.rf.x86_64.rpm for RHEL4 on x86_64.
\nOnce you have the required package install it. For example:<\/p>\n
rpm -Uvh perl-Curses-1.13-1.1.el3.rf.i386.rpm<\/p>\n
Alternate if you have DAG in your up2date sources you can install perl-Curses simply by:<\/p>\n
up2date perl-Curses<\/p>\n
Optional in case you don\u2019t have already perl-DBI and perl-DBD, then install them using up2date:<\/p>\n
up2date perl-DBD-MySQL perl-DBI<\/p>\n
The other requirements (Getopt::Long, Net::Domain) are normally part of the base install and are already available.<\/p>\n
Now that you have all the required dependencies installed all you need is the mtop sources. Uncompress them and use the readme instructions for installation:<\/p>\n
perl Makefile.PL
\nmake
\nmake install<\/p>\n
Alternate you can use the rpm available on DAG (I have not tested those rpm packages):
\nhttp:\/\/dag.wieers.com\/packages\/mtop\/<\/p>\n
As Robeto, has suggested, in case you already have DAG in your sources for up2date or yum, you can install it with all the required dependencies very easy using:<\/p>\n
yum install mtop
\nor
\nup2date mtop<\/p>\n
based on what is the tool you are using (yum or up2date).<\/p>\n
To summarize Redhat\/ContOS install;<\/p>\n
wget http:\/\/dag.wieers.com\/rpm\/packages\/perl-Curses\/perl-Curses-1.23-1.rh9.rf.i386.rpm
\nrpm -Uvh perl-Curses-1.23-1.rh9.rf.i386.rpm
\nyum install mtop<\/p>\n","protected":false},"excerpt":{"rendered":"
Mtop (MySQL Monitoring Tool) mtop screen Mtop is a little perl utility that shows in real time statistics of your MySQL server. It allows you to quickly identify problems related to mysql poor performance, using an interface similar to the normal \u2018top\u2019 command. If you are using Debian then the installation is trivial as mtop… <\/p>\n