Good suggestions. I checked the mysql.rrd and it has lots of NaN entries.
shall i delete it and create a new one.
[hobbit at linux ~]$ rrdtool dump data/rrd/abc2.acd.com/mysql.rrd | more
<!-- Round Robin Database Dump --><rrd> <version> 0003 </version>
<step> 300 </step> <!-- Seconds -->
<lastupdate> 1173155037 </lastupdate> <!-- 2007-03-05 20:23:57 PST
-->
<ds>
<name> threads </name>
<type> DERIVE </type>
<minimal_heartbeat> 600 </minimal_heartbeat>
<min> NaN </min>
<max> NaN </max>
<!-- PDP Status -->
<last_ds> 42 </last_ds>
<value> NaN </value>
<unknown_sec> 237 </unknown_sec>
</ds>
<ds>
<name> questions </name>
<type> DERIVE </type>
<minimal_heartbeat> 600 </minimal_heartbeat>
<min> NaN </min>
<max> NaN </max>
<!-- PDP Status -->
<last_ds> 207587169 </last_ds>
<value> NaN </value>
<unknown_sec> 237 </unknown_sec>
</ds>
<ds>
<name> slowqueries </name>
<type> DERIVE </type>
<minimal_heartbeat> 600 </minimal_heartbeat>
<min> NaN </min>
<max> NaN </max>
<!-- PDP Status -->
<last_ds> 10 </last_ds>
<value> NaN </value>
<unknown_sec> 237 </unknown_sec>
Regards
Sabeer MZ
On 3/5/07, Jones, Jason (Altrincham) <user-ee957b46acd2@xymon.invalid> wrote:
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:user-00a5e44c48c0@xymon.invalid]
Sent: 05 March 2007 12:52
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections
On 3/5/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> 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
--
Warm Regards
Sabeer MZ