influxctl database create
Limited availability
InfluxDB Clustered is currently only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.
The influxctl database create command creates a new database with a specified
retention period in an InfluxDB cluster.
The retention period defines the maximum age of data retained in the database,
based on the timestamp of the data.
The retention period value is a time duration value made up of a numeric value
plus a duration unit. For example, 30d means 30 days.
A zero duration retention period is infinite and data will not expire.
The retention period value cannot be negative or contain whitespace.
Valid durations units include
- m: minute
- h: hour
- d: day
- w: week
- mo: month
- y: year
Example retention period values
0d: infinite/none3d: 3 days6w: 6 weeks1mo: 1 month (30 days)1y: 1 year30d30d: 60 days2.5d: 60 hours
Usage
influxctl database create [--retention-period 0s] <DATABASE_NAME>
Arguments
| Argument | Description |
|---|---|
| DATABASE_NAME | InfluxDB database name |
Flags
| Flag | Description | |
|---|---|---|
--retention-period | Database retention period (default is 0s or infinite) | |
--max-tables | Maximum tables per database (default is 500, 0 uses default) | |
--max-columns | Maximum columns per table (default is 250, 0 uses default) | |
-h | --help | Output command help |
Examples
- Create a database with an infinite retention period
- Create a database with a 30-day retention period
- Create a database with non-default table and column limits
Create a database with an infinite retention period
influxctl database create mydb
Create a database with a 30-day retention period
influxctl database create \
--retention-period 30d \
mydb
Create a database with non-default table and column limits
influxctl database create \
--max-tables 200 \
--max-columns 150 \
mydb
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:
Customers with an annual or support contract can contact InfluxData Support.