High Memory Usage Problem in influx version - 1.2.2

1

Hi

version : 1.2.2
The number of fields : About 8000

I have hard time because of High Memory Usage Problem

Currently, the Influx process is using 40 g of 64 g memory.

Also, this momory usage is rising continuously.

About reason on such a subject, I guess because i run this query - “select (*) every field from …”

After running the query, influx client is dead.

These Things can affect high memory usage problem?

plz answer me.

thanks.

2

Hi Wook welcome ,

do you have plans to upgrade , the most recent version is 1.7.6 ,

is there a time limit on your query , I mean for example "where time > now() -1d "
what is the output of

influxd config|grep -i index

best regards ,

3

Hi ,

I am also facing this issue sometimes.
and the output of influxd config | grep -i index is
Merging with configuration at: /etc/influxdb/influxdb.conf
index-version = “inmem”

4

Hi @Gobiviswa ,

this may be helpfull …

Starting with the InfluxDB 1.6 release, enabling Time Series Index (TSI) is recommended for all customers. To learn more about TSI, see:

* [Time Series Index (TSI) overview](https://docs.influxdata.com/influxdb/v1.7/concepts/time-series-index/)
* [Time Series Index (TSI) details](https://docs.influxdata.com/influxdb/v1.7/concepts/tsi-details/)

The upgrade steps below guide you in upgrading InfluxDB OSS and InfluxDB Enterprise, enabling TSI functionality.

> ***Note:***  For the InfluxDB 1.7 release, the default continues to use TSM-based shards as in earlier versions, with in-memory indexes.