influxctl database update

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


influxctl database update [flags] <DATABASE_NAME>


DATABASE_NAMEName of the database to update


--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


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!

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