Setting multiple values with sum

Asked by Jens Rantil on 2012-04-13

Hi,

When having a Whisper database with aggregationMethod=sum, will doing

my.event 1 1334217576
my.event 1 1334217576
my.event 1 1334217576

yield a value of 3 or value of 1 (ie. simply resetting the value)?

Question information

Language:
English Edit question
Status:
Solved
For:
Graphite Edit question
Assignee:
No assignee Edit question
Solved by:
Michael Leinartas
Solved:
2012-04-16
Last query:
2012-04-16
Last reply:
2012-04-16
Best Michael Leinartas (mleinartas) said : #1

That example will result in a value of 1. The aggregationMethod setting only influences the way in which aggregations happen when points move from a higher resolution to a lower resolution at retention boundaries.

For instance, for a retention config of 10s:1d, 60s:7d (in storage-schemas.conf)

Sending:
my.event 1 1334217480
my.event 1 1334217490
my.event 1 1334217500
my.event 1 1334217510
my.event 1 1334217520
my.event 1 1334217530

Will result in those 5 points being stored for 1 day. After 1 day, with aggregationMethod=sum, only this point will be available:
my.event 6 1334217480

With aggregationMethod=avg (the default), it will instead be
my.event 1 1334217480

In short, multiple points sent during the time bucket lining up with your highest resolution (say 1334217480 to 1334217489 seconds) will be overwritten and only the last one kept. If you need to do aggregation it should either be done by the sender or by an external process (statsd being the most common).

Jens Rantil (jens-rantil) said : #2

Ah, thanks!

Jens Rantil (jens-rantil) said : #3

Thanks Michael Leinartas, that solved my question.