[hobbit] MySQL graphing woes

[Dominique Frise]

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