Welcome to UltratechHost Forum, Guest. Please take the time to register if you haven't, or click

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

[-]
Tags
how to install mytop a top clone for mysql

How To Install MyTOP - a top clone for MySQL
#1
In this howto i will describe how to install mytop package on CentOS 5.7. MyTOP is top command clone to monitor mysql performance including queries, threads etc. You can get source of it from here to build or you can use rpmforge repositories for pre-build rpms. The machine i used to demonstrte is in production and getting very high mysql access, its running on CentOS 5.7.

1 Setting Up RPMForge Repository

RPMForge repository (http://dag.wieers.com) is the biggest rpm respository for RHEL, CentOS for all versions. To enable RPMForge respository run following command. The following command directly install rpm from http://dag.wieers.com site.

Code:
rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm

This rpm will add necessary files in our repository configuration and can be viewed at /etc/yum.repos.d/rpmforge.repo

2 Install MyTOP

Use yum to install mytop on your machine

Code:
yum -y install mytop

It will install mytop with all necessary pre-requisite to run mytop.

3 Running MyTOP


To run use

Code:
mytop

if you have restricted access using password then

Code:
mytop -u root -p <password> -h localhost

NOTE: You may get following error in CentOS 5.3

PHP Code:
Error in option spec“long|!” 

to fix above issue run
Code:
chmod 755 /usr/bin/mytop
nano /usr/bin/mytop

Search for the line

Code:
“long|!”              => \$config{long_nums},

Change it to by commenting using #

Code:
#”long|!”              => \$config{long_nums},

Now run the command again and it will run fine and you can see mytop giving all the information about you mysql server.

Code:
mytop
(This post was last modified: 10-09-2011, 08:20 AM by UltratechHost.)


Dinesh Kumar Mohanty
Ultra Web Solutions®
Bhubaneswar, Odisha, India.

UltratechHost - Your One Stop Offshore & Onshore Hosting Provider
Server Locations : Netherlands, Germany, Russia, Singapore & USA
Service Offers: Shared hosting | Reseller hosting | Cloud server | Dedicated server | VPS Hosting



Forum Jump:


Users browsing this thread: 1 Guest(s)