I have influx db (v.1.6.0) with about 25 million records and retention policy
DURATION 30w REPLICATION 1 SHARD DURATION 4h. Some services write data (not too much - about 100 per sec), some services read these data.
And I noticed that influx server (VDS, 8 CPU, 16G RAM) sometimes (randomly) starts to serve queries very long time (~1min and above). It causes to go down all services Queries aren’t complicated, with simple WHERE conditions
Is it because of wrong retention policy? May be I should change it?
I mean if WHERE clause in query has time period more 4h - is it can be the reason of overhead?