[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [hobbit] graphs with external script
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