mysql connections

list Jason Altrincham Jones
Mon, 5 Mar 2007 16:37:23 -0000
Message-Id: <user-d5e4f47043a1@xymon.invalid>

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