Projects/InfluxDB Setup: Difference between revisions
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
CREATE CONTINUOUS QUERY CQ_15min ON weather BEGIN SELECT median(value) AS value INTO weather._10years.:MEASUREMENT FROM weather."default"./^[a-z].*/ GROUP BY time(15m), * fill(none) END | CREATE CONTINUOUS QUERY CQ_15min ON weather BEGIN SELECT median(value) AS value INTO weather._10years.:MEASUREMENT FROM weather."default"./^[a-z].*/ GROUP BY time(15m), * fill(none) END | ||
SELECT median(value) AS value INTO weather._10years.:MEASUREMENT FROM weather."default"./^[a-z].*/ where time > now() - 1d GROUP BY time(15m), * fill(none) | |||
|} | |} | ||
* 360000 measurement, 5.76MB at 16Byte per measurement | * 360000 measurement, 5.76MB at 16Byte per measurement | ||
Revision as of 17:30, 4 June 2016
Objective
- Provide a Database for measurements
- Manage memory smartly:
- Allow for high sampling rates e.g. 4 values/second
- Short retention for high sampling rate data e.g. 1 hour
- Multiple levels of automatic down-sampling using aggregation with increasing retention for each level
Retention and Down-Sampling
| sample rate/aggregate | retention | # of values | InfluxDB Retention and Continuous Query Setup |
|---|---|---|---|
| 0.25 seconds (raw data) | 1 hour | 14400 |
CREATE RETENTION POLICY default ON weather DURATION 1h REPLICATION 1 DEFAULT |
| 15 minutes | 10 years | 345600 |
CREATE RETENTION POLICY _10years ON weather DURATION 1d REPLICATION 1 CREATE CONTINUOUS QUERY CQ_15min ON weather BEGIN SELECT median(value) AS value INTO weather._10years.:MEASUREMENT FROM weather."default"./^[a-z].*/ GROUP BY time(15m), * fill(none) END SELECT median(value) AS value INTO weather._10years.:MEASUREMENT FROM weather."default"./^[a-z].*/ where time > now() - 1d GROUP BY time(15m), * fill(none) |
- 360000 measurement, 5.76MB at 16Byte per measurement