IOx storage engine limits
The InfluxDB IOx storage enforces specific limits on the storage level.
Terminology
- namespace: organization+bucket
- table: measurement
- column: time, tags and fields are structured as columns
Service-level limits
The IOx storage engine enforces the following storage-level limits:
- Maximum number of tables per namespace: 500
- Maximum number of columns per table: 200
IOx storage service-level limits are configurable per namespace. To adjust your service-level limits, contact InfluxData Support.
Error messages
Maximum number of columns reached
couldn't create columns in table `table_name`; table contains
<N> existing columns, applying this write would result
in <N+> columns, limit is 200
This error is returned for any write request that would exceed the maximum number of columns allowed in a table.
Potential solutions
- Consider storing new fields in a new measurement.
- Contact InfluxData Support to delete any unnecessary data.
Maximum number of tables reached
dml handler error: service limit reached: couldn't create new table; namespace contains <N> existing
tables, applying this write would result in <N+> columns, limit is 500
This error is returned for any write request that would exceed the maximum number of tables allowed in a namespace.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.