is there a way to optimize influxdb other than switching to TSI?
i am using TSI already it didn’t affect the load(memory usage) much.
@neo1702 some general thoughts:
- with
inmem
index, a large number of series can cause high memory usage because the entire index is held in-memory - with
tsi
, a large number of shards can cause high memory usage because there is an index per shard and part of each shard’s index is held in memory. - there’s no exact upper limit on number of series with
inmem
or upper limit on number of shards withtsi
because that’s affected by the amount of memory available. Generally though, I would say < 10M series withinmem
and < 500 shards withtsi
.
How many series and shards do you have?
around 100,000 per day