Note
This variable was introduced in V1.4.
Description
The auto_increment_cache_size variable specifies the number of auto-increment values to be cached.
Privilege requirements
- Query variables
Users in the sys tenant and all users in other tenant can execute the SHOW VARIABLES statement or query the information_schema.GLOBAL_VARIABLES view (MySQL mode) to view the value of a global system variable.
Modify variables
Users in the
systenant can directly modify the value of a global system variable.MySQL users in other tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | int |
| Default value | 1000000 |
| Value range | [1, 100000000] |
| Scope | GLOBAL |
| Modifiable | Yes. You can modify the value by using the SET statement.|
Example
obclient> SET GLOBAL auto_increment_cache_size = 1000000;