MySQL Activity Report : FAQ
I want to rebuild mysqlard but I've installed rrdtool in a location where configure can't find it, what should I do to point configure to my rrdtool installation ?
You can point configure to any location you want to by using environment variables, run configure --help to see all environment variables it uses.
This specific problem can be solved by setting the LDFLAGS and CPPFLAGS before running configure.
If you installed rrdtool in /usr/local/rrdtool-1.0.42 for instance, the commands you need to run in your shell prior to running configure are:
LDFLAGS=\'-L/usr/local/rrdtool-1.0.42/lib\' ; export LDFLAGS CPPFLAGS=\'-I/usr/local/rrdtool-1.0.42/include\' ; export CPPFLAGS
Starting with version 1.0.0 you can pass the location of the rrdtool installation to configure:
./configure --with-rrd=/usr/local/rrdtool-1.0.42
I've installed the package but I don't see any graphs using the example php script.
You need to add a cron job to generate the graphs. For example :
*/5 * * * * hourly=1 daily=1 weekly=1 monthly=1 /usr/bin/mysqlar_graph > /dev/null
This will generate hourly, daily, weekly and monthly graphs in ${imgdir}, /var/lib/mysqlard/ in most cases, every 5 minutes and mail you if something went wrong, otherwise it keeps quiet.
If you'd like yearly graphs you can add yearly=1 to the environment, but that doesn't make sense if you just started using the prog.