<br><br>Good suggestions. I checked the mysql.rrd and it has lots of NaN entries.<br>shall i delete it and create a new one.<br><br>[hobbit@linux ~]$ rrdtool dump data/rrd/abc2.acd.com/mysql.rrd | more<br><!-- Round Robin Database Dump --><rrd> <version> 0003 </version>

<br>        <step> 300 </step> <!-- Seconds --><br>        <lastupdate> 1173155037 </lastupdate> <!-- 2007-03-05 20:23:57 PST --><br><br>        <ds><br>                <name> threads </name>

<br>                <type> DERIVE </type><br>                <minimal_heartbeat> 600 </minimal_heartbeat><br>                <min> NaN </min><br>                <max> NaN </max>

<br><br>                <!-- PDP Status --><br>                <last_ds> 42 </last_ds><br>                <value> NaN </value><br>                <unknown_sec> 237 </unknown_sec><br>

        </ds><br><br>        <ds><br>                <name> questions </name><br>                <type> DERIVE </type><br>                <minimal_heartbeat> 600 </minimal_heartbeat>

<br>                <min> NaN </min><br>                <max> NaN </max><br><br>                <!-- PDP Status --><br>                <last_ds> 207587169 </last_ds><br>                <value> NaN </value>

<br>                <unknown_sec> 237 </unknown_sec><br>        </ds><br><br>        <ds><br>                <name> slowqueries </name><br>                <type> DERIVE </type>

<br>                <minimal_heartbeat> 600 </minimal_heartbeat><br>                <min> NaN </min><br>                <max> NaN </max><br><br>                <!-- PDP Status -->

<br>                <last_ds> 10 </last_ds><br>                <value> NaN </value><br>                <unknown_sec> 237 </unknown_sec><br><br>Regards<br>Sabeer MZ<br><br><div><span class="gmail_quote">

On 3/5/07, <b class="gmail_sendername">Jones, Jason (Altrincham)</b> <<a href="mailto:JasonAS_Jones@mentor.com">JasonAS_Jones@mentor.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

Try:<br><br>/<rrd install dir>/bin/rrdtool dump /<hobbit install dir>/data/<servername>/<testname>.rrd | more<br><br>You should see the data declarations for the database should be something like:<br>

<br><!-- Round Robin Database Dump --><br><rrd><br>        <version> 0003 </version><br>        <step> 300 </step> <!-- Seconds --><br>        <lastupdate> 1173112124 </lastupdate> <!-- 2007-03-05 16:28:44 GMT -->

<br><br>        <ds><br>                <name> runtime </name><br>                <type> GAUGE </type><br>...<br><!-- 2007-03-03 22:40:00 GMT / 1172961600 --> <row><v> 1<br>

.0503600000e+01 </v></row><br>                        <!-- 2007-03-03 22:45:00 GMT / 1172961900 --> <row><v> 1<br>.0325800000e+01 </v></row><br>                        <!-- 2007-03-03 22:50:00 GMT / 1172962200 --> <row><v> 1

.1187333333e+01 </v></row>                          <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.

<br><br>Jason.<br><br>-----Original Message-----<br>From: Ralph Mitchell [mailto:<a href="mailto:ralphmitchell@gmail.com">ralphmitchell@gmail.com</a>]<br>Sent: 05 March 2007 12:52<br>To: <a href="mailto:hobbit@hswn.dk">hobbit@hswn.dk

</a><br>Subject: Re: [hobbit] mysql connections<br><br>On 3/5/07, Sabeer MZ <<a href="mailto:sabeer.mz@gmail.com">sabeer.mz@gmail.com</a>> wrote:<br>><br>> Hopefully you are referring to change below lines.  I am not experienced guy

<br>> and got below code<br>> from mailing list. please let me know which line i have to correct it.<br>><br>> [mysql]<br>>        DEF:t=mysql.rrd:threads:AVERAGE<br>>        DEF:q=mysql.rrd:questions:AVERAGE

<br>>        DEF:s=mysql.rrd:slowqueries:AVERAGE<br>>        TITLE Monitoring MySQL<br>>        YAXIS count<br>>        LINE1:q#FF0000:Requês<br>>        GPRINT:q:LAST: \: %3.0lf (cur)<br>>         GPRINT:q:MAX: \: %3.0lf (max)

<br>>        GPRINT:q:MIN: \: %3.0lf (min)<br>>        GPRINT:q:AVERAGE: \: %3.0lf (avg)\n<br>>        LINE1:s#0000FF:Req. lentes<br>>        GPRINT:s:LAST: \: %3.0lf (cur)<br>>        GPRINT:s:MAX: \: %3.0lf (max)

<br>>        GPRINT:s:MIN: \: %3.0lf (min)<br>>        GPRINT:s:AVERAGE: \: %3.0lf (avg)\n<br>>        LINE1:t#00FF00:Threads<br>>        GPRINT:t:LAST: \: %3.0lf (cur)<br>>        GPRINT:t:MAX: \: %3.0lf (max)

<br>>        GPRINT:t:MIN: \: %3.0lf (min)<br>>        GPRINT:t:AVERAGE: \: %3.0lf (avg)\n<br>><br><br>Nope, it's probably not the above, which is for drawing the graph.<br>The error message says:<br><br>   RRD error updating /home/hobbit/data/rrd/abx.acc.com/mysql.rrd

<br><br>note where it says "updating".  Isn't that on the input side, not the<br>the graph drawing side??<br><br>Ralph Mitchell<br><br>To unsubscribe from the hobbit list, send an e-mail to<br><a href="mailto:hobbit-unsubscribe@hswn.dk">

hobbit-unsubscribe@hswn.dk</a><br><br><br><br>To unsubscribe from the hobbit list, send an e-mail to<br><a href="mailto:hobbit-unsubscribe@hswn.dk">hobbit-unsubscribe@hswn.dk</a><br><br><br></blockquote></div><br><br clear="all">

<br>-- <br>Warm Regards<br>Sabeer MZ