High CPU usage by influxdb

InfluxDB 2
#1

I am relatively new to time series db world . I am running a Influxdb 1.8.x as a docker container, and I have configured the influxdb.conf file as a default config. Currently I am facing a issue of high CPU usage by influxdb, the CPU jumps to 80 to 90% and creating a problem for other process running on same machine. I have tried a solution given here ->> CPU issue but unfortunately It did not work? I am unable to understand the reason behind the issue and also struggling to get support in terms of documentation or community help.

profiles_new.tar.gz (177.6 KB) vars.txt (36.1 KB)

#2

Are you running this on a PI? What is your workload like? How much storage are you using?

#3

@kramik1 Thanks for your comment! Here is my configuration
I am running this in a Docker Environment / Docker Swarm, where each of the Nodes has a configuration of 16 cores and 32 GB RAM and the resources are not restricted currently by docker.

#4

Are there any restrictions on any of the containers? Do you have dedicated SSD storage for influxdb containers? Have you looked at dashboards for influxdb’s internal metrics? I took a quick look at the metrics and see some fields for query response times. Just speaking generically, your database should be able to cache a lot of the often queried data in memory and should have at least 4 CPU cores just to start in production. How many queries are you running a second? The metrics has numbers for how many active queries there are.

https://docs.influxdata.com/platform/monitoring/influxdata-platform/tools/measurements-internal/#fluxqueryreqdurationns

Welcome
Events
Legal
Blog
Careers
Community
InfluxData
799 Market Street, Suite 400
San Francisco, CA 94103
© 2018 InfluxData, Inc.