Ingestion (ILP/HTTP)

These settings control data ingestion via InfluxDB Line Protocol (ILP). ILP over HTTP is the preferred ingestion method. ILP over TCP is available for legacy workloads. UDP is deprecated.

For general HTTP server settings (port, buffers, connections), see the HTTP server configuration.

General​

line.auto.create.new.columns​

  • Default: true
  • Reloadable: no

When enabled, automatically creates new columns when they appear in the ingested data. When disabled, messages with new columns will be rejected.

line.auto.create.new.tables​

  • Default: true
  • Reloadable: no

When enabled, automatically creates new tables when they appear in the ingested data. When disabled, messages for non-existent tables will be rejected.

line.default.partition.by​

  • Default: DAY
  • Reloadable: no

Table partition strategy for tables created automatically by ILP. Possible values are: HOUR, DAY, WEEK, MONTH, and YEAR.

line.log.message.on.error​

  • Default: true
  • Reloadable: no

Controls whether malformed ILP messages are printed to the server log when errors occur.

HTTP​

ILP over HTTP is the preferred way of ingesting data.

line.http.enabled​

  • Default: true
  • Reloadable: no

Enable ILP over HTTP. Default port is 9000. Enabled by default in open source versions, defaults to false and must be explicitly enabled for Enterprise.

line.http.ping.version​

  • Default: v2.2.2
  • Reloadable: no

Version information for the ping response of ILP over HTTP.

TCP​

line.tcp.auth.db.path​

  • Default: none
  • Reloadable: no

Path to the authentication database file.

line.tcp.commit.interval.default​

  • Default: 1000
  • Reloadable: no

Default commit interval in milliseconds.

line.tcp.commit.interval.fraction​

  • Default: 0.5
  • Reloadable: no

Commit lag fraction. Used to calculate the commit interval for a table: commit_interval = commit_lag * fraction. The calculated interval defines how long uncommitted data remains uncommitted.

line.tcp.connection.pool.capacity​

  • Default: 64
  • Reloadable: no

Maximum number of pooled connections for this interface.

line.tcp.disconnect.on.error​

  • Default: true
  • Reloadable: no

Disconnect TCP sockets that send malformed messages.

line.tcp.enabled​

  • Default: true
  • Reloadable: no

Enable or disable ILP over TCP.

line.tcp.io.worker.affinity​

  • Default: none
  • Reloadable: no

Comma-separated list of CPU core indexes to pin I/O worker threads to. Core indexes are 0-based.

line.tcp.io.worker.count​

  • Default: 0
  • Reloadable: no

Number of dedicated I/O worker threads for parsing TCP input. When 0, uses the shared worker pool.

line.tcp.io.worker.sleep.threshold​

  • Default: 1000
  • Reloadable: no

Number of consecutive idle loop iterations before the I/O worker goes to sleep.

line.tcp.io.worker.yield.threshold​

  • Default: 10
  • Reloadable: no

Number of consecutive idle loop iterations before the I/O worker thread yields.

line.tcp.maintenance.job.interval​

  • Default: 1000
  • Reloadable: no

Maximum time in milliseconds between maintenance jobs committing uncommitted data on inactive tables.

line.tcp.max.measurement.size​

  • Default: 32768
  • Reloadable: no

Maximum size of any measurement.

line.tcp.min.idle.ms.before.writer.release​

  • Default: 500
  • Reloadable: no

Minimum idle time in milliseconds before a table writer is released.

line.tcp.msg.buffer.size​

  • Default: 32768
  • Reloadable: no

Size of the buffer read from the queue. Maximum size of a write request, regardless of the number of measurements.

line.tcp.net.bind.to​

  • Default: 0.0.0.0:9009
  • Reloadable: no

IP address and port for the TCP listener. By default, listens on all network interfaces.

line.tcp.net.connection.hint​

  • Default: false
  • Reloadable: no

Windows-specific flag to overcome OS limitations on TCP backlog size.

line.tcp.net.connection.limit​

  • Default: 256
  • Reloadable: yes

Maximum number of simultaneous connections. Controls server memory consumption.

line.tcp.net.connection.queue.timeout​

  • Default: 5000
  • Reloadable: no

Time in milliseconds a connection can wait in the listen backlog queue before it is refused. Connections are aggressively removed from the backlog until the active connection limit is breached.

line.tcp.net.connection.rcvbuf​

  • Default: -1
  • Reloadable: no

Maximum receive buffer size on each TCP socket. If set to -1, the socket receive buffer remains unchanged from OS defaults.

line.tcp.net.connection.timeout​

  • Default: 300000
  • Reloadable: no

Connection idle timeout in milliseconds. Connections are closed by the server when this timeout lapses.

line.tcp.timestamp​

  • Default: n
  • Reloadable: no

Input timestamp resolution. Possible values are n, u, ms, s, and h.

line.tcp.writer.halt.on.error​

  • Default: false
  • Reloadable: no

Flag that indicates if the writer thread must stop when an unexpected error occurs.

line.tcp.writer.queue.capacity​

  • Default: 128
  • Reloadable: no

Size of the queue between I/O jobs and writer jobs. Each queue entry represents a measurement.

line.tcp.writer.worker.affinity​

  • Default: none
  • Reloadable: no

Comma-separated list of CPU core indexes to pin writer worker threads to. Core indexes are 0-based.

line.tcp.writer.worker.count​

  • Default: 0
  • Reloadable: no

Number of dedicated I/O worker threads for writing data to tables. When 0, uses the shared worker pool.

line.tcp.writer.worker.sleep.threshold​

  • Default: 1000
  • Reloadable: no

Number of consecutive idle loop iterations before the writer worker goes to sleep.

line.tcp.writer.worker.yield.threshold​

  • Default: 10
  • Reloadable: no

Number of consecutive idle loop iterations before the writer worker thread yields.

UDP (deprecated)​

note

The UDP receiver is deprecated since QuestDB version 6.5.2. We recommend ILP over HTTP instead.

line.udp.bind.to​

  • Default: 0.0.0.0:9009
  • Reloadable: no

IP address and port for the UDP listener. By default, listens on all network interfaces.

line.udp.commit.mode​

  • Default: nosync
  • Reloadable: no

Commit durability. Available values are nosync, sync, and async.

line.udp.commit.rate​

  • Default: 1000000
  • Reloadable: no

For packet bursts, the number of continuously received messages after which the receiver will force a commit. The receiver commits regardless of this parameter when there are no messages.

line.udp.enabled​

  • Default: false
  • Reloadable: no

Enable or disable the UDP receiver.

line.udp.join​

  • Default: 232.1.2.3
  • Reloadable: no

Multicast address the receiver joins. Ignored when the receiver is in unicast mode.

line.udp.msg.buffer.size​

  • Default: 2048
  • Reloadable: no

Buffer used to receive a single message. Should be roughly equal to your MTU size.

line.udp.msg.count​

  • Default: 10000
  • Reloadable: no

Linux only. Maximum number of messages to receive at once via the recvmmsg() system call.

line.udp.own.thread​

  • Default: false
  • Reloadable: no

When true, the UDP receiver uses its own thread with busy spin for performance. When false, the receiver uses shared worker threads.

line.udp.own.thread.affinity​

  • Default: -1
  • Reloadable: no

CPU core to pin the receiver thread to. -1 means no affinity (OS schedules the thread). Only valid when line.udp.own.thread is true.

line.udp.receive.buffer.size​

  • Default: 8388608
  • Reloadable: no

UDP socket buffer size. Larger buffers help reduce message loss during bursts.

line.udp.timestamp​

  • Default: n
  • Reloadable: no

Input timestamp resolution. Possible values are n, u, ms, s, and h.

line.udp.unicast​

  • Default: false
  • Reloadable: no

When true, UDP uses unicast. Otherwise multicast.