[rrd-users] Weird numbers in my database

Brandon Knitter knitterb at blandsite.org
Wed Oct 23 20:53:21 MEST 2002


Hi there.  I'm trying to shove some data into my rrd, and the numbers that are
coming out are WAY off.  I'm assuming I'm doing something wrong.  Please help me
find my error!?!?

I made my rrd with the following:

    $RRDTOOL create "$i" \
        -s 300 \
        DS:miss_ratio:ABSOLUTE:900:0:U \
        DS:db_buffer_hit_ratio:ABSOLUTE:900:0:U \
        DS:sql_cache_hit_ratio:ABSOLUTE:900:0:U \
        DS:Rb_cont_undo_block:ABSOLUTE:900:0:U \
        DS:Rb_cont_undo_header:ABSOLUTE:900:0:U \
        DS:lib_cache_miss_rati:ABSOLUTE:900:0:U \
        DS:Rb_cont_sys_undo_hd:ABSOLUTE:900:0:U \
        DS:Rb_cont_sys_undo_bl:ABSOLUTE:900:0:U \
        \
        RRA:MIN:0.5:3:2016 \
        RRA:AVERAGE:0.5:3:2016 \
        RRA:MAX:0.5:3:2016 \
        \
        RRA:MIN:0.5:12:8064 \
        RRA:AVERAGE:0.5:12:8064 \
        RRA:MAX:0.5:12:8064 \
        \
        RRA:MIN:0.5:48:24192 \
        RRA:AVERAGE:0.5:48:24192 \
        RRA:MAX:0.5:48:24192 \
        \
        RRA:MIN:0.5:288:72576 \
        RRA:AVERAGE:0.5:288:72576 \
        RRA:MAX:0.5:288:72576

And my logs state that I'm adding in a number about 0.07 every 5 minutes.  I ab
logging the line which puts it in, so I'm certain that's what's going in.  My
lines look like:

line=N:0.072859:U:U:U:U:U:U:U
line=N:0.072860:U:U:U:U:U:U:U
line=N:0.072860:U:U:U:U:U:U:U
line=N:0.072861:U:U:U:U:U:U:U
line=N:0.072862:U:U:U:U:U:U:U
line=N:0.072864:U:U:U:U:U:U:U
line=N:0.072864:U:U:U:U:U:U:U
line=N:0.072864:U:U:U:U:U:U:U


But when I do a dump of the RRD, and check out the MAX section of the RRS
(RRA:MAX:0.5:3:2016) I am getting this near the bottom (recent):


            <!-- 2002-10-23 09:30:00 PDT / 1035390600 --> <row><v>
2.4147625692e-04 </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN
</v><v> NaN </v><v> NaN </v></row>
            <!-- 2002-10-23 09:45:00 PDT / 1035391500 --> <row><v>
2.4147892222e-04 </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN
</v><v> NaN </v><v> NaN </v></row>
            <!-- 2002-10-23 10:00:00 PDT / 1035392400 --> <row><v>
2.4175291251e-04 </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN
</v><v> NaN </v><v> NaN </v></row>
            <!-- 2002-10-23 10:15:00 PDT / 1035393300 --> <row><v>
2.4113359760e-04 </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN
</v><v> NaN </v><v> NaN </v></row>
            <!-- 2002-10-23 10:30:00 PDT / 1035394200 --> <row><v>
2.4181684444e-04 </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN
</v><v> NaN </v><v> NaN </v></row>
            <!-- 2002-10-23 10:45:00 PDT / 1035395100 --> <row><v>
2.4188360000e-04 </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN </v><v> NaN
</v><v> NaN </v><v> NaN </v></row>


How the heck does 0.07 become 0.00024?????

Thanks in advance!

-- 
-bk





--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi



More information about the rrd-users mailing list