Hi,
Are the mysql rrd file in the hobbit/data/rrd/ filesystem ? are they updated ?
are the "mysqlslow" and "mysqlthread" present in your $GRAPHS variable ?
Regards,
Olivier
Selon Etienne Roulland <Etienne.Roulland at cvf.fr>:
Hi Etienne,
Hi Etienne ;)
Did you put the name of your trends in the different configuration files ?
You should have add information in :
the rrd part in hobbitgraph.cfg
[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n
[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n
the rrdstatus in hobbitlaunch.cfg
[rrdstatus] ENVFILE /usr2/hobbit/server/etc/hobbitserver.cfg NEEDS hobbitd CMD hobbitd_channel --channel=status --log= $BBSERVERLOGS/rrd-status.log hobbitd_rrd --rrddir=$BBVAR/rrd --debug
My RRD files seem to be correctly updated:
2005-08-26 15:31:55 RRD update param 00: 'rrdupdate' 2005-08-26 15:31:55 RRD update param 01: '/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd' 2005-08-26 15:31:55 RRD update param 02: '-t' 2005-08-26 15:31:55 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-08-26 15:31:55 RRD update param 04: '1125063115:211:359216582:801:30426:3:511:71.713'
the TEST2RRD and GRAPHS in hobbitserver.cfg
TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv,
$PINGCOLUMN=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperat....
GRAPHS="la,mysql,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,temperature,ntpstat,apache,bind,sendmail....
But no graphes ...
Etienne
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
-- Olivier Beau