Answer the question
In order to leave comments, you need to log in
Is it possible to thin data in influxdb?
The project was configured to monitor a large number of metrics every minute. This amount is not needed, reconfigured. But the historical data remained in the database, which I would like to "thin out" a little in order to reduce the size of the database.
Is there some way to make a smart query in influxdb to thin out the data in a particular measurements?
For example "on each interval of 5 minutes, leave the first entry, delete the rest"
Answer the question
In order to leave comments, you need to log in
you can try using into to move the downsampled data to another mezherment, delete the old one, rename the new one to the old one
https://docs.influxdata.com/influxdb/v1.8/query_la...
PS
saw your answers (you seem to be experienced) and I did not immediately write a warning,
but now I thought - the children will read.
The link on the page has examples of how to split queries so that, with a large amount of data, you do not kill the database with INTO queries. Read carefully )
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question