Yep this make sense to take profit from continuous queries.
I would try something like this, put all my flows in influxdb in a db
with a low retention policy, and get the metric I want to keep from
continuous queries in a separate db with higher retention.
Ram was not my fear, as you said it was cheap, but more the disk IOs on
big queries ?
--
Raphael Mazelier
On 11/11/2016 10:23, Catalin Petrescu wrote:
Hi Raphael,
We are doing one measurment for each netflow exporter. Also we keep only
the data for 60 days ( retention policy on influxdb ). On top of that we
run continuous queries to generate a new measurment for total traffic in/
total traffic in from transit/peers , this are the most used graphs by our
noc.
Even with above influxdb still uses ~10G of ram constant. I beleive this
can be optimised if you don't use that many primitives and/or use less
tags.
Ram is cheap anyway so for us it does the job.
Regards,
Catalin
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists