when trying to reduce the memory usage of a small scale database by reviewing the behavior changes of different config parameters, there are some strange effects visible:
The starting point on a silent plain database system (neither writes nor reads have been activated):
(a) A minimal system by turning off any unused services like subscriber and continuous_queries,
(b) With a completely empty database (together with step a) the InfluxDB uses about 300MB of virtual memory,
Importing a database from backup (size 350 MB) leads to a virtual memory usage of 600-650 MB.
That means that more than 85% of the data is held within the memory. Does anyone has got a clue how to reduce this memory allocation?
Some trial-and-error tuning steps:
(1) changing shard index from inmem to tsi1
more-or-less no effects (difference less than 20 MB)
(2) lowering or increasing cache-max-memory-size and/or cache-snapshot-memory-size
(of course) no effects on virtual memory
(3) disabling of retention and shard-precreation
no visible effects
Are there any parameters to be changed to reduce the amount of virtual memory usage?
Any pointers appreciated! Thanks in advance.