Note
This parameter is available starting with V4.3.4.
Description
enable_auto_split specifies whether to enable automatic partition splitting for a tenant.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | BOOL |
| Default value | FALSE |
| Value range |
|
| 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. |
Considerations
You can use the ALTER SYSTEM SET statement to modify the value of this parameter.
The enable_auto_split parameter specifies whether to create an automatic partition table when you create a table without using the PARTITION clause to explicitly enable automatic partitioning. If you explicitly set the automatic partitioning attribute for a table, this parameter does not take effect.
- If
enable_auto_splitistrue, only tables that meet the requirements for automatic partitioning are created as automatic partition tables. - If
enable_auto_splitisfalseand you change it totruelater, the change only takes effect for newly created tables that meet the requirements for automatic partitioning.
For more information about automatic partition splitting, see Automatic partition splitting (MySQL mode) or Automatic partition splitting (Oracle mode).
Examples
Enable automatic partition splitting.
ALTER SYSTEM SET enable_auto_split = TRUE;