InfluxDB 2.x: Task: Downsampling: Unterschied zwischen den Versionen
Admin (Diskussion | Beiträge) |
Admin (Diskussion | Beiträge) |
||
| Zeile 23: | Zeile 23: | ||
== Downsampling Example calculation == | == Downsampling Example calculation == | ||
For example we are writting '''200 Metric-points per second''', this means: | For example we are writting '''200 Metric-points per second''', this means: | ||
| − | *'''12'000''' Metric-points per minute | + | *~ '''12'000''' Metric-points per minute |
| − | *'''720'000''' Metric-points per hour | + | *~ '''720'000''' Metric-points per hour |
| − | *'''17'280'000''' Metric-points per day | + | *~ '''17'280'000''' Metric-points per day |
| − | *'''518' | + | *~ '''518'000'000''' Metric-points per month |
| − | + | ||
| + | Assumption we have following Buckets (InfluxDB's): | ||
| + | * | ||
Version vom 14. Dezember 2020, 14:21 Uhr
Flux (Tasks) - InfluxDB 2.x
Flux is InfluxData’s functional data scripting language designed for querying, analyzing, and acting on data. Beginning with InfluxDB 1.8.0, Flux is available for production use along side InfluxQL.
More information's about "Flux Tasks": https://docs.influxdata.com/influxdb/v2.0/process-data/common-tasks/downsample-data/#example-downsampling-task-script
InfluxQL - InfluxDB 1.x
InfluxQL is an SQL-like query language for interacting with InfluxDB. It has been crafted to feel familiar to those coming from other SQL or SQL-like environments while also providing features specific to storing and analyzing time series data. However InfluxQL is not SQL and lacks support for more advanced operations like UNION, JOIN and HAVING that SQL power-users are accustomed to. This functionality is available with Flux.
More information's about "Continuous Queries": https://docs.influxdata.com/influxdb/v1.8/query_language/continuous_queries/
Downsampling Example calculation
For example we are writting 200 Metric-points per second, this means:
- ~ 12'000 Metric-points per minute
- ~ 720'000 Metric-points per hour
- ~ 17'280'000 Metric-points per day
- ~ 518'000'000 Metric-points per month
Assumption we have following Buckets (InfluxDB's):
