content/shared/influxctl/database/update.md
The influxctl database update command updates a database's retention period,
table (measurement), or column limits in InfluxDB.
influxctl database update [flags] <DATABASE_NAME>
| Argument | Description |
|---|---|
| DATABASE_NAME | Name of the database to update |
| 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 |
{{% caption %}}
Also see influxctl global flags.
{{% /caption %}}
influxctl database update --retention-period 1mo mydb
{{< flex >}} {{% flex-content "half" %}}
m: minuteh: hourd: dayw: weekmo: monthy: year{{% /flex-content %}} {{% flex-content "half" %}}
0d: infinite/none3d: 3 days6w: 6 weeks1mo: 1 month (30 days)1y: 1 year30d30d: 60 days2.5d: 60 hours{{% /flex-content %}} {{< /flex >}}
influxctl database update --max-tables 300 mydb
influxctl database update --max-columns 200 mydb