Documentation

Manage databases

InfluxDB 3 Core is in Public Alpha

InfluxDB 3 Core is in public alpha and available for testing and feedback, but is not meant for production use. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the alpha and invite you to join our public channels for updates and to share feedback.

Alpha expectations and recommendations

An InfluxDB 3 Core database is a named location where time series data is stored. Each database can contain multiple tables.

If coming from InfluxDB v1, the concepts of databases and retention policies have been combined into a single concept–database. Retention policies are no longer part of the InfluxDB data model. However, InfluxDB 3 Core does support InfluxQL, which requires databases and retention policies. See InfluxQL DBRP naming convention.

If coming from InfluxDB v2, InfluxDB Cloud (TSM), or InfluxDB Cloud Serverless, database and bucket are synonymous.

Database, table, and column limits

InfluxDB 3 Core places the following limits on databases, tables, and columns:

Database limit

Maximum number of databases: 5

Table limit

Maximum number of tables across all databases: 2000

InfluxDB 3 Core limits the number of tables you can have across all databases to 2000. There is no specific limit on how many tables you can have in an individual database, as long as the total across all databases is below the limit.

Having more tables affects your InfluxDB 3 Core installation in the following ways:

May improve query performance View more info

More PUTs into object storage View more info

More work for the compactor (Enterprise only) View more info

Column limit

Maximum number of columns per table: 500

Each row must include a time column, with the remaining columns representing tags and fields. As a result, a table can have one time column and up to 499 combined field and tag columns. If you attempt to write to a table and exceed the column limit, the write request fails and InfluxDB returns an error.

Higher numbers of columns has the following side-effects:

May adversely affect system performance


Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

InfluxDB 3 Open Source Now in Public Alpha

InfluxDB 3 Open Source is now available for alpha testing, licensed under MIT or Apache 2 licensing.

We are releasing two products as part of the alpha.

InfluxDB 3 Core, is our new open source product. It is a recent-data engine for time series and event data. InfluxDB 3 Enterprise is a commercial version that builds on Core’s foundation, adding historical query capability, read replicas, high availability, scalability, and fine-grained security.

For more information on how to get started, check out: