Hi All I am inserting a low volume of data (less than 2000 points every 15 minutes). I do this via a Java program (using a batch). What I have noticed is inserting the same amount of data takes longer and longer and over time and the CPU usage constantly increases (almost linearly) over 24 hours (It is not swapping as far as I can see).
If I restart InfluxDB the CPU usage goes back to normal for a while but it slowly and steadily climbs with each insert. The only thing that reduces the CPU load for writes (roughly the same amount of data every time) is if I restart InfluxDB (I have tried stopping and starting the Java program and it has no effect (I thought it might be holding onto ports etc). I am using a very small server (1G / 1 CPU) to test it (there is very little data) but I was wondering if I am configuring InfluxDB properly. I am using version 1.0.2 of InfluxDB on Ubuntu Linux (on DigitalOcean) and the "recommended" Java library. Here is my conf file reporting-disabled = false bind-address = ":8088" [meta] dir = "/var/lib/influxdb/meta" retention-autocreate = true logging-enabled = true [data] dir = "/var/lib/influxdb/data" engine = "tsm1" wal-dir = "/var/lib/influxdb/wal" wal-logging-enabled = true query-log-enabled = false cache-max-memory-size = 524288000 cache-snapshot-memory-size = 26214400 cache-snapshot-write-cold-duration = "1h0m0s" compact-full-write-cold-duration = "24h0m0s" max-points-per-block = 0 max-series-per-database = 1000000 trace-logging-enabled = false [coordinator] write-timeout = "10s" max-concurrent-queries = 0 query-timeout = "0" log-queries-after = "0" max-select-point = 0 max-select-series = 0 max-select-buckets = 0 [retention] enabled = true check-interval = "30m0s" [shard-precreation] enabled = true check-interval = "10m0s" advance-period = "30m0s" [admin] enabled = true bind-address = ":8083" https-enabled = false https-certificate = "/etc/ssl/influxdb.pem" [monitor] store-enabled = true store-database = "_internal" store-interval = "10s" [subscriber] enabled = true http-timeout = "30s" write-concurrency = 40 write-buffer-size = 1000 [http] enabled = true bind-address = ":8086" auth-enabled = false log-enabled = false write-tracing = false https-enabled = false https-certificate = "/etc/ssl/influxdb.pem" https-private-key = "" max-row-limit = 10000 max-connection-limit = 0 shared-secret = "" realm = "InfluxDB" [continuous_queries] log-enabled = true enabled = true run-interval = "1s" Any pointers will be appreciated. Regards Steve van der Merwe -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/005a183d-a55b-4a00-a884-7d089ff62934%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
