Note
This variable is available starting with V1.4.
Description
auto_increment_cache_size specifies the number of cached auto-increment values.
Privilege requirements
Query variables
The
systenant and all user tenants can query the value of a Global system variable by using theSHOW VARIABLESstatement or theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode).Modify variables
The
systenant can directly modify the value of a Global system variable.A MySQL user tenant can modify the value of a Global system variable only when it has the
SUPERorALTER SYSTEMprivilege.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 1000000 |
| Value range | [1, 100000000] |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the number of cached auto-increment values to 1000000.
obclient> SET GLOBAL auto_increment_cache_size = 1000000;