[rrd-users] Strange GAUGE values when parsing MySQL output

Simon Hobson linux at thehobsons.co.uk
Tue Aug 11 21:32:02 CEST 2009


Arthur Meeks Meeks wrote:

>The problem is:
>
>When I get the data from the MySQL, as I said, I get data such as:
>0
>1
>2
>etc
>
>But those values are included in the rrd file as:
>             <!-- 2009-08-11 20:20:00 CEST / 1250014800 --> <row><v> 
>1.6333333333e-01 </v></row>
>             <!-- 2009-08-11 20:25:00 CEST / 1250015100 --> <row><v> 
>3.6666666667e-02 </v></row>
>             <!-- 2009-08-11 20:30:00 CEST / 1250015400 --> <row><v> 
>0.0000000000e+00 </v></row>
>             <!-- 2009-08-11 20:35:00 CEST / 1250015700 --> <row><v> 
>0.0000000000e+00 </v></row>
>             <!-- 2009-08-11 20:40:00 CEST / 1250016000 --> <row><v> 
>0.0000000000e+00 </v></row>
>
>So the grahp is not showing the correct values, cause it should be 
>1, 2...but instead it shows: 100M, 200M in the vertical axis

See Rates, normalizing and consolidating on Alex's RRD pages 
http://www.vandenbogaerdt.nl/rrdtool/

What you have described is correct RRD tool behaviour - you only 
think it's wrong because you haven't been introduced to the key 
features of RRD. Once you understand what it's doing and why, it 
won't seem wrong.

-- 
Simon Hobson

Visit http://www.magpiesnestpublishing.co.uk/ for books by acclaimed
author Gladys Hobson. Novels - poetry - short stories - ideal as
Christmas stocking fillers. Some available as e-books.



More information about the rrd-users mailing list