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 OKthreads: 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).