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