Note
This parameter is available starting with V1.4.
Description
autoinc_cache_refresh_interval specifies the interval for refreshing the cache of auto-increment columns.
Privilege requirements
Query the parameter
You can execute the
SHOW PARAMETERSstatement to query this parameter in thesystenant and all user tenants.Modify the parameter
You can modify this parameter only in the
systenant. User tenants cannot modify this 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 auto-increment column cache refresh interval to 3600s.
obclient> ALTER SYSTEM SET autoinc_cache_refresh_interval ='3600s';