Thanks for reply
command: dmesg -T | grep Out
results:
[Wed Nov 27 00:42:04 2019] Out of memory in UB 4227: OOM killed process 7583 (influxd) score 0 vm:35778656kB, rss:2723912kB, swap:0kB
[Wed Nov 27 00:43:53 2019] Out of memory in UB 4227: OOM killed process 7595 (influxd) score 0 vm:35779388kB, rss:2719388kB, swap:0kB
[Wed Nov 27 00:46:25 2019] Out of memory in UB 4227: OOM killed process 7626 (influxd) score 0 vm:37329112kB, rss:2715688kB, swap:0kB
[Wed Nov 27 00:46:55 2019] Out of memory in UB 4227: OOM killed process 7684 (influxd) score 0 vm:35877676kB, rss:2717184kB, swap:0kB
[Wed Nov 27 00:48:29 2019] Out of memory in UB 4227: OOM killed process 7704 (influxd) score 0 vm:35714356kB, rss:2727696kB, swap:0kB
[Wed Nov 27 00:50:54 2019] Out of memory in UB 4227: OOM killed process 7732 (influxd) score 0 vm:35886628kB, rss:2718696kB, swap:0kB
[Wed Nov 27 00:53:24 2019] Out of memory in UB 4227: OOM killed process 7802 (influxd) score 0 vm:37098900kB, rss:2720124kB, swap:0kB
[Wed Nov 27 00:55:56 2019] Out of memory in UB 4227: OOM killed process 7839 (influxd) score 0 vm:35766440kB, rss:2717400kB, swap:0kB
[Wed Nov 27 00:57:09 2019] Out of memory in UB 4227: OOM killed process 7899 (influxd) score 0 vm:35753140kB, rss:2715324kB, swap:0kB
database works without problems for 12 months. Now is quite big - data directory is approximately 80Gb
I tried switch engine to TSI according to: Upgrade to InfluxDB 1.8.x | InfluxDB OSS v1 Documentation
To enable TSI in InfluxDB 1.7.x, complete the following steps:
a. If using the InfluxDB configuration file, find the [data]
section, uncomment index-version = "inmem"
and change the value to tsi1
.
b. If using environment variables, set INFLUXDB_DATA_INDEX_VERSION
to tsi1
.
c. Delete shard index
directories (by default, located at /<shard_ID>/index
).
d. Convert TSM-based shards to TSI-based shards by running the influx_inspect buildtsi command.
but after this operation log looks like that:
2019-11-27T06:46:53.763618Z info index opened with 8 partitions {"log_id": "0JMuZ8Yl000", "index": "tsi"}
2019-11-27T06:46:53.766147Z info Reading file {"log_id": "0JMuZ8Yl000", "engine": "tsm1", "service": "cacheloader", "path": "/var/lib/influxdb/wal/liczniki/autogen/418/_01945.wal", "size": 455749}
2019-11-27T06:46:53.768512Z info Reading file {"log_id": "0JMuZ8Yl000", "engine": "tsm1", "service": "cacheloader", "path": "/var/lib/influxdb/wal/liczniki/autogen/416/_02339.wal", "size": 133}
2019-11-27T06:46:53.779122Z info Reading file {"log_id": "0JMuZ8Yl000", "engine": "tsm1", "service": "cacheloader", "path": "/var/lib/influxdb/wal/liczniki/autogen/416/_02341.wal", "size": 267}
I’m not sure if everything works fine becouse of: "index": "tsi"
and "engine": "tsm1"