Hi All,
Can someone please help me to configure the optimum performance for DISK IO and RAM usage?
Specially for,
INFLUXDB_DATA_CACHE_MAX_MEMORY_SIZE: “xx”
INFLUXDB_DATA_CACHE_SNAPSHOT_MEMORY_SIZE: “xx”
INFLUXDB_DATA_MAX_CONCURRENT_COMPACTIONS: 3
INFLUXDB_DATA_COMPACT_THROUGHPUT,
INFLUXDB_DATA_COMPACT_THROUGHPUT_BURST,
INFLUXDB_DATA_TSM_USE_MADV_WILLNEED,
INFLUXDB_COORDINATOR_MAX_CONCURRENT_QUERIES,
etc?
I am using Centos 8, 64GB RAM, 2ocps
Thanks & Regards,
Hi All,
Currently i am seeing this,
Thanks in advance
Hi @LochanaMendis- Are you seeing some error or specific performance issue? Out-of-the-box, InfluxDB is configured for most use-cases. Changing the default settings requires more context on your workload or response to some specific error condition. Also, what storage type are you using? Influx strongly recommends using SSD’s with 2000+ IOPS minimum.
HI @chobbs, thanks for the reply. Yes i am seeing huge read IOs recorded in iostat. I am seeing very slow loading of grafana dashboards connected to influxdb. I am not using SSDs.
Is there a way to optimize the disk utilization?
Thanks in advance,
Lochana
understood @LochanaMendis- your best options is going to be to upgrade to SSD’s - all influx
HW specs require this storage type for perf. There are some config settings that can help with disk util, but generally focused on ingest. I’m not sure what your query profile looks like, but you may take a look at some of the read optimizations tips. Might help general query performance, but just a bit
