IOx storage engine limits
The InfluxDB IOx storage enforces specific limits on the storage level.
- namespace: organization+bucket
- table: measurement
- column: time, tags and fields are structured as columns
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.
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.
- 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.