influxctl database update

The influxctl database update command updates a database’s retention period, table (measurement), or column limits in InfluxDB.

Usage

influxctl database update [flags] <DATABASE_NAME>

Arguments

ArgumentDescription
DATABASE_NAMEName of the database to update

Flags

FlagDescription
--retention-periodDatabase retention period (default is 0s or infinite)
--max-tablesMaximum tables per database (default is 500, 0 uses default)
--max-columnsMaximum columns per table (default is 250, 0 uses default)
-h--helpOutput command help

Examples

Update a database’s retention period

influxctl database update --retention-period 1mo mydb
Valid durations units
  • m: minute
  • h: hour
  • d: day
  • w: week
  • mo: month
  • y: year
Example retention period values
  • 0d: infinite/none
  • 3d: 3 days
  • 6w: 6 weeks
  • 1mo: 1 month (30 days)
  • 1y: 1 year
  • 30d30d: 60 days
  • 2.5d: 60 hours

Update a database’s table limit

influxctl database update --max-tables 300 mydb

Update a database’s column limit

influxctl database update --max-columns 200 mydb

Was this page helpful?

Thank you for your feedback!