S
S
Saboteur2022-01-24 12:22:32
Database
Saboteur, 2022-01-24 12:22:32

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

1 answer(s)
E
Eugene, 2022-01-24
@saboteur_kiev

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 question

Ask a Question

731 491 924 answers to any question