Note
This parameter is available starting with V1.4.
Description
autoinc_cache_refresh_interval specifies the cache refresh interval for auto-increment columns.
Privilege requirements
Query the parameter
You can query the parameter by using the
SHOW PARAMETERSstatement in thesystenant and all user tenants.Modify the parameter
Only the
systenant can modify the parameter. User tenants cannot modify the parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 3600s |
| Value range | [100ms, +∞) |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Set the cache refresh interval for auto-increment columns to 3600s.
obclient> ALTER SYSTEM SET autoinc_cache_refresh_interval ='3600s';