[rrd-users] Weird numbers in my database

[Brandon Knitter]

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