MySQL Activity Report CentOS

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"

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

# wget http://people.ee.ethz.ch/~oetiker/we...-1.2.14.tar.gz
# tar -xvzf rrdtool-1.2.14.tar.gz
# cd rrdtool-1.2.14
# ./configure
# make
# make install
# make site-perl-install
# cd ..
# rm -rf rrdtool-1.2.14
Now, you need to install (MySQL Activity Report) mysqlard

# cd /tmp
# wget http://freshmeat.net/redir/mysqlard/...d-1.0.0.tar.gz
# tar -xvzf mysqlard-1.0.0.tar.gz
# cd mysqlard-1.0.0
You need to compile I mean configure this using below metiond steps:

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

# ./configure

-OR-

# ./configure --prefix=/usr --sysconfdir=/etc --datadir=/var/lib
You can also specify the rrd and mysql path if you are facing any error while compiling

--with-rrd=PATH : set the full path to your rrdtool installation
--with-mysql=PATH: set the full path to your mysql installation

# make
# make install
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:

# cp /var/lib/mysqlard/mysqlard.cnf /etc
Edit the mysqlard.cnf file and add search for below mentioend string

RRDTOOL=""
provide the exact path of your rrdtool

save and exit

# 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
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