[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