<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I'm setting up mysql checks and graphing using the hobbit-modified
bb-mysql.pl. I have the statuses working fine:<br>
<h3> Thu Apr 12 04:42:40 2007 MySQL Server OK</h3>
<pre>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
</pre>
However, instead of a graph at the bottom, I just have:<br>
"hobbit graph ncv:mysql" next to the hourglass. I'm using Hobbit 4.20
plus the latest "all in one" patch.<br>
<br>
Here are the relevant sections from my config files, hopefully someone
can point out what I'm doing wrong?<br>
hobbitserver.cfg:<br>
<tt>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"<br>
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"<br>
NCV_mysql="*:GAUGE"</tt><br>
<br>
hobbitgraph.cfg (these are the default entries that come with Hobbit):<br>
<tt>[mysqlslow]<br>
DEF:slow=mysql.rrd:Slowqueries:AVERAGE<br>
TITLE MySQL Slow Queries<br>
YAXIS #<br>
LINE2:slow#00CCCC:Slow Queries<br>
COMMENT:\n<br>
GPRINT:slow:LAST: \: %5.1lf (cur)<br>
GPRINT:slow:MAX: \: %5.1lf (max)<br>
GPRINT:slow:MIN: \: %5.1lf (min)<br>
GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n<br>
<br>
[mysqlthread]<br>
DEF:threads=mysql.rrd:Threads:AVERAGE<br>
TITLE MySQL Active Threads<br>
YAXIS #<br>
AREA:threads#00CCCC:Threads<br>
COMMENT:\n<br>
GPRINT:threads:LAST: \: %5.1lf (cur)<br>
GPRINT:threads:MAX: \: %5.1lf (max)<br>
GPRINT:threads:MIN: \: %5.1lf (min)<br>
GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n</tt><br>
<br>
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:<br>
<i><tt>$ rrdtool dump mysql.rrd |egrep 'name|value' | head -20</tt></i><br>
<tt> <name> threads </name><br>
<value> 2.6730000000e+03 </value><br>
<name> questions </name><br>
<value> 8.1735172200e+08 </value><br>
<name> slowqueries </name><br>
<value> 6.2488800000e+05 </value><br>
<name> opens </name><br>
<value> 9.0288000000e+04 </value><br>
<name> flushtables </name><br>
<value> 8.9100000000e+02 </value><br>
<name> opentables </name><br>
<value> 2.9700000000e+04 </value><br>
<name> queriespersecondavg </name><br>
<value> 2.5239060000e+03 </value><br>
<name> maxcon </name><br>
<value> 1.1880000000e+05 </value><br>
<name> Uptime </name><br>
<value> 8.9100000000e+02 </value><br>
<name> Serverreportstimest </name><br>
<value> 1.5444000000e+04 </value></tt><br>
<br>
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).<br>
</body>
</html>