[hobbit] mysql connections

[Jones, Jason (Altrincham)]

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