[hobbit] mysql connections

[Sabeer MZ]

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) <JasonAS_Jones at mentor.com> 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: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
>
>
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk
>
>
>


-- 
Warm Regards
Sabeer MZ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20070306/d366167c/attachment.html>