Try:
/<rrd install dir>/bin/rrdtool dump /<hobbit install dir>/data/<servername>/<testname>.rrd | more
You should see the data declarations for the database should be something like:
<!-- Round Robin Database Dump --> <rrd> <version> 0003 </version> <step> 300 </step> <!-- Seconds --> <lastupdate> 1173112124 </lastupdate> <!-- 2007-03-05 16:28:44 GMT -->
<ds>
<name> runtime </name>
<type> GAUGE </type>... <!-- 2007-03-03 22:40:00 GMT / 1172961600 --> <row><v> 1 .0503600000e+01 </v></row> <!-- 2007-03-03 22:45:00 GMT / 1172961900 --> <row><v> 1 .0325800000e+01 </v></row> <!-- 2007-03-03 22:50:00 GMT / 1172962200 --> <row><v> 1 .1187333333e+01 </v></row> <!-- 2007-03-03 22:55:00 GMT / 1172962500 --> <row><v> 1 .0944200000e+01 </v></row>
The values below ... aren't relevant just that it doesn't say NaN (there may be a few initial lines that do) after the timestamp though make sure the <type> and <name> setting are what you expect them to be.
Jason.
-----Original Message----- From: Ralph Mitchell [mailto:ralphmitchell at gmail.com] Sent: 05 March 2007 12:52 To: hobbit at hswn.dk Subject: Re: [hobbit] mysql connections
On 3/5/07, Sabeer MZ <sabeer.mz at gmail.com> wrote:
Hopefully you are referring to change below lines. I am not experienced guy and got below code from mailing list. please let me know which line i have to correct it.
[mysql] DEF:t=mysql.rrd:threads:AVERAGE DEF:q=mysql.rrd:questions:AVERAGE DEF:s=mysql.rrd:slowqueries:AVERAGE TITLE Monitoring MySQL YAXIS count LINE1:q#FF0000:Requês GPRINT:q:LAST: \: %3.0lf (cur) GPRINT:q:MAX: \: %3.0lf (max) GPRINT:q:MIN: \: %3.0lf (min) GPRINT:q:AVERAGE: \: %3.0lf (avg)\n LINE1:s#0000FF:Req. lentes GPRINT:s:LAST: \: %3.0lf (cur) GPRINT:s:MAX: \: %3.0lf (max) GPRINT:s:MIN: \: %3.0lf (min) GPRINT:s:AVERAGE: \: %3.0lf (avg)\n LINE1:t#00FF00:Threads GPRINT:t:LAST: \: %3.0lf (cur) GPRINT:t:MAX: \: %3.0lf (max) GPRINT:t:MIN: \: %3.0lf (min) GPRINT:t:AVERAGE: \: %3.0lf (avg)\n
Nope, it's probably not the above, which is for drawing the graph. The error message says:
RRD error updating /home/hobbit/data/rrd/abx.acc.com/mysql.rrd
note where it says "updating". Isn't that on the input side, not the the graph drawing side??
Ralph Mitchell
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk