[rrd-users] graph/rrd def for small increment monitoring

[Kevin P. Foote]

Thanks Darren 

I'm still polling using the same rrd ... 

When graphing I now create the DEF value from my rrd and then multiply
the value by 300 using a CDEF. This should now give me the 5 minute window 
rather than the 1 second as mentioned before..  ??.. ??.. Yes?

Now at least the values look more in-line with what I would have expected 
them to be ... 

Just making sure that I understood your response back and that I'm
interpreting the numbers correctly. :-)


------
thanks
  kevin.foote

On Thu, 3 Sep 2009, A Darren Dunham wrote:

-> On Thu, Sep 03, 2009 at 04:08:48PM -0400, Kevin P. Foote wrote:
-> > I'm trying to monitor a (hopefully) low value attribute within mysql,
-> > slow_query count.
-> > 
-> > I have setup my rra like the following basing my input on results from this mysql
-> > command (SHOW GLOBAL STATUS like 'Slow_queries') this is an increasing
-> > count of slow queries on this server.
-> > 
-> > 
-> > filename = "my_slow_query.rrd"
-> > rrd_version = "0003"
-> > step = 300
-> > last_update = 1252007704
-> > ds[count].type = "COUNTER"
-> 
-> Okay.
-> 
-> > The data at start of polling this value was 95 .. it has increased to
-> > 139 over the past 4 hours or so .. with most entries into the rra being
-> > the same (but using type COUNTER this should be a LAST of 0) ...
-> 
-> 139 - 95 => 44
-> 44 / (4 hours) => average of .003/second or 3m (milli) queries / second.
-> 
-> > When I get the graph back the resolution on the Y axis is showing 80 m
-> > ... this should rather be something like 8 I would think... And the
-> > Maximal value Im GPRINTing is showing 76.75m ..
-> 
-> Since you have some zeros, and the average is 3m, I think a few peaks of
-> 75m doesn't seem unreasonable.  Remember, it's not showing values at a
-> point in time, it's showing rates between points in time.
-> 
-> Maybe slow queries per second isn't a useful number for you.  Perhaps
-> multiplying by a factor and showing slow queries per minute or per hour
-> would be better?
-> 
-> Or also, it could be that graphing short periods of time isn't useful
-> and it would be better to only graph bigger buckets (like hours).
-> 
-> -- 
-> Darren
-> 
-> _______________________________________________
-> rrd-users mailing list
-> rrd-users at lists.oetiker.ch
-> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
->