How To: MySQL Activity Report

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"

Quote:

# cd /tmp

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

Quote:

# 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

Quote:

# 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

Quote:

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

Quote:

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

Quote:

# cp /var/lib/mysqlard/mysqlard.cnf /etc

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

Quote:

RRDTOOL=""

provide the exact path of your rrdtool

save and exit

Quote:

# 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