How To: MySQL Activity Report
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
# ./configure --prefix=/usr --sysconfdir=/etc --datadir=/var/lib
Basic, installation is completed. For configuration:
--with-rrd=PATH : set the full path to your rrdtool installation
--with-mysql=PATH: set the full path to your mysql installation
# make install
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
# cp /var/lib/mysqlard/mysqlard.cnf /etc
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.
# cd /var/lib/mysqlard
# cp mysqlar.monthly /etc/cron.monthly
# cp mysqlar.weekly /etc/cron.weekly
# cp mysqlar.daily /etc/cron.daily
now start the daemon:
# ./mysqlard.server initrrd
# ./mysqlard.server start
restart the httpd services
Open your browser and browse the URL:
This how you could install mysqlar :) Enjoy