Hi,
I’m new to InfluxDB and wonder if I can switch off console output on windows. I start influxd.exe and then every write action is logged (printed) to console which slows down the DB extremely.
Best regards
Michael
That’s up to your configuration, especially the logging section
Can you share your current config?
Well, it’s the default:
reporting-disabled = false
bind-address = “127.0.0.1:8088”
[meta]
dir = “C:\Users\di29394\.influxdb\meta”
retention-autocreate = true
logging-enabled = true
[data]
dir = “C:\Users\di29394\.influxdb\data”
index-version = “inmem”
wal-dir = “C:\Users\di29394\.influxdb\wal”
wal-fsync-delay = “0s”
validate-keys = false
query-log-enabled = true
cache-max-memory-size = 1073741824
cache-snapshot-memory-size = 26214400
cache-snapshot-write-cold-duration = “10m0s”
compact-full-write-cold-duration = “4h0m0s”
compact-throughput = 50331648
compact-throughput-burst = 50331648
max-series-per-database = 1000000
max-values-per-tag = 100000
max-concurrent-compactions = 0
max-index-log-file-size = 1048576
series-id-set-cache-size = 100
trace-logging-enabled = false
tsm-use-madv-willneed = false
[coordinator]
write-timeout = “10s”
max-concurrent-queries = 0
query-timeout = “0s”
log-queries-after = “0s”
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”
[monitor]
store-enabled = true
store-database = “_internal”
store-interval = “10s”
[subscriber]
enabled = true
http-timeout = “30s”
insecure-skip-verify = false
ca-certs = “”
write-concurrency = 40
write-buffer-size = 1000
[http]
enabled = true
bind-address = “:8086”
auth-enabled = false
log-enabled = true
suppress-write-log = false
write-tracing = false
flux-enabled = false
flux-log-enabled = false
pprof-enabled = true
pprof-auth-enabled = false
debug-pprof-enabled = false
ping-auth-enabled = false
https-enabled = false
https-certificate = “/etc/ssl/influxdb.pem”
https-private-key = “”
max-row-limit = 0
max-connection-limit = 0
shared-secret = “”
realm = “InfluxDB”
unix-socket-enabled = false
unix-socket-permissions = “0777”
bind-socket = “/var/run/influxdb.sock”
max-body-size = 25000000
access-log-path = “”
max-concurrent-write-limit = 0
max-enqueued-write-limit = 0
enqueued-write-timeout = 30000000000
[logging]
format = “auto”
level = “info”
suppress-logo = false
[[graphite]]
enabled = false
bind-address = “:2003”
database = “graphite”
retention-policy = “”
protocol = “tcp”
batch-size = 5000
batch-pending = 10
batch-timeout = “1s”
consistency-level = “one”
separator = “.”
udp-read-buffer = 0
[[collectd]]
enabled = false
bind-address = “:25826”
database = “collectd”
retention-policy = “”
batch-size = 5000
batch-pending = 10
batch-timeout = “10s”
read-buffer = 0
typesdb = “/usr/share/collectd/types.db”
security-level = “none”
auth-file = “/etc/collectd/auth_file”
parse-multivalue-plugin = “split”
[[opentsdb]]
enabled = false
bind-address = “:4242”
database = “opentsdb”
retention-policy = “”
consistency-level = “one”
tls-enabled = false
certificate = “/etc/ssl/influxdb.pem”
batch-size = 1000
batch-pending = 5
batch-timeout = “1s”
log-point-errors = true
[[udp]]
enabled = false
bind-address = “:8089”
database = “udp”
retention-policy = “”
batch-size = 5000
batch-pending = 10
read-buffer = 0
batch-timeout = “1s”
precision = “”
[continuous_queries]
log-enabled = true
enabled = true
query-stats-enabled = false
run-interval = “1s”
[tls]
min-version = “”
max-version = “”
A possible solution for Windows might be:
influxd.exe -config influxdb.config > NUL 2> NUL
Meanwhile I understood, that writing is slow not because of output on console but because I wrote every single value separately instead of writing batches.
Best regards
Michael
If you read the configuration docs you can find all the information you need. sadly influxdb does not offer the possibility to log to a file (at least in its conf file) but you can manually redirect the output.
You can also check out this short and basic guide I made about configuring influxdb on windows
