The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How To : MySql Activity monitor

Discussion in 'General Discussion' started by Manuel_accu, Oct 7, 2006.

  1. Manuel_accu

    Manuel_accu Well-Known Member

    Joined:
    Jun 19, 2005
    Messages:
    191
    Likes Received:
    0
    Trophy Points:
    16
    Hi,

    While searching for myaql performance report base tool for php. I have found wonderful tool for mysql performance checking and report generation.

    It is deemon called mysqlard (MySQL Activity Report) it presents useful graphs by processing the data to enforce a certain data density. The main goal of the package is to help the database system administrator in tuning the system for maximum performance.

    This package contains example graphing, cron and PHP script.

    Before installing this package you need to have "rrdtool" install. I have described the step how to install and monitor the use this tool:

    First you need to install "rrdtool"

    download the rrdtool:
    rrdtool's home page is : http://people.ee.ethz.ch/~oetiker/webtools/rrdtool/

    Now, you need to install (MySQL Activity Report) mysqlard

    You need to compile I mean configure this using below metiond steps:

    You could use only confiure option if have all is well set

    You can also specify the rrd and mysql path if you are facing any error while compiling

    Basic, installation is completed. For configuration:

    You will find the file named mysqlard.cnf at /etc folder. if this file not created by default then you have copy from the below mentioned folder:

    Edit the mysqlard.cnf file and add search for below mentioend string

    provide the exact path of your rrdtool

    save and exit

    You need to set the correct permission for apache users and set the alias in your httpd conf file for var/lib/mysqlard folder.

    restart the httpd services

    Open your browser and browse the URL:

    http://yourserverIP/<alias>/mysqlar.php

    This how you could install mysqlar :) Enjoy

    Thanks!
     
Loading...

Share This Page