[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [hobbit] mysql connections

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