Note
This parameter is available starting with V4.3.4.
Description
auto_split_tablet_size specifies the threshold for triggering automatic partition splitting when automatic partitioning is enabled 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 | CAPACITY |
| Default value | 2GB
NoteThe default value of this parameter was changed to 2GB starting with V4.4.1. |
| Value range | [128M, +∞) |
| 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
Use the ALTER SYSTEM SET statement to modify the value of this parameter.
When you create or modify a table that has automatic partitioning enabled but no automatic partitioning threshold is specified, the value of this parameter is used as the automatic partitioning threshold. If the disk space occupied by a partition exceeds the threshold, automatic partition splitting is triggered.
Notice
Modifying this parameter does not affect automatically partitioned tables that have already been created.
Examples
Set the splitting threshold to 256 MB.
AlTER SYSTEM SET auto_split_tablet_size = '256MB';