[hobbit] MySQL graphing woes

[Sabeer MZ]

There is good number of emails exchanged regarding mysql monitoring using
hobbit.
Please have a look on the last few months mail archive.


On 4/12/07, Dominique Frise <Dominique.Frise at unil.ch> wrote:
>
> Charles Jones wrote:
> > I'm setting up mysql checks and graphing using the hobbit-modified
> > bb-mysql.pl. I have the statuses working fine:
> >
> >
> >       Thu Apr 12 04:42:40 2007 MySQL Server OK
> >
> > threads: 10
> > questions: 2751997
> > slow queries: 2100
> > opens: 304
> > flush tables: 3
> > open tables: 100
> > queries per second avg: 8.514
> > maxcon: 400
> >
> > Server version: 4.1.9-standard-log
> > Uptime: 3 days 17 hours 47 min 3 sec
> >
> > Server reports timestamp of 2007-04-12 04:42:40
> >
> >
> > However, instead of a graph at the bottom, I just have:
> > "hobbit graph ncv:mysql" next to the hourglass. I'm using Hobbit 4.20
> > plus the latest "all in one" patch.
> >
> > Here are the relevant sections from my config files, hopefully someone
> > can point out what I'm doing wrong?
> > hobbitserver.cfg:
> >
> TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendmail,mailq,nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,files,procs=processes,ports,clock,lines,mysql=ncv"
> > GRAPHS="la,disk,inode,qtree,files,processes,memory,users,vmstat,iostat,
> tcp.http
> ,tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,bind,sendmail,mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines,mysql:mysqlslow,mysql:mysqlthread"
> > NCV_mysql="*:GAUGE"
> >
> > hobbitgraph.cfg (these are the default entries that come with Hobbit):
> > [mysqlslow]
> >         DEF:slow=mysql.rrd:Slowqueries:AVERAGE
> >         TITLE MySQL Slow Queries
> >         YAXIS #
> >         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
> >         YAXIS #
> >         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
> >
> > Note I have also dumped out one of the rrd files, and they have data, so
> > I don't think the problem lies with my NCV definition:
> > /$ rrdtool dump mysql.rrd |egrep 'name|value' | head -20/
> >                 <name> threads </name>
> >                 <value> 2.6730000000e+03 </value>
> >                 <name> questions </name>
> >                 <value> 8.1735172200e+08 </value>
> >                 <name> slowqueries </name>
> >                 <value> 6.2488800000e+05 </value>
> >                 <name> opens </name>
> >                 <value> 9.0288000000e+04 </value>
> >                 <name> flushtables </name>
> >                 <value> 8.9100000000e+02 </value>
> >                 <name> opentables </name>
> >                 <value> 2.9700000000e+04 </value>
> >                 <name> queriespersecondavg </name>
> >                 <value> 2.5239060000e+03 </value>
> >                 <name> maxcon </name>
> >                 <value> 1.1880000000e+05 </value>
> >                 <name> Uptime </name>
> >                 <value> 8.9100000000e+02 </value>
> >                 <name> Serverreportstimest </name>
> >                 <value> 1.5444000000e+04 </value>
> >
> > So there we have it...the data is getting to Hobbit and being stored in
> > the rrd files, it's just not displaying the graphs for some reason, and
> > at the moment I can't see why. I searched the email archive and found
> > lots of other posts of people having similar problems, with various
> > solutions, none of which seem to work (yes I restart Hobbit after
> > editing hobbitserver.cfg).
>
> Your GRAPHS variable should be:
>
> GRAPHS="la,disk,inode,qtree,files,processes,memory,users,vmstat,iostat,
> tcp.http
> ,tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,bind,sendmail,mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines,mysql"
>
> In bb-hosts set the TRENDS directive for the host(s) like this:
>
> TRENDS:*,mysql:mysqlslow|mysqlthreads
>
>
> Dominique
> UNIL - University of Lausanne
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk
>
>
>


-- 
Thanks
Sabeer MZ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20070412/8df36b64/attachment.html>