mitto

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!