Note
This parameter was introduced in V4.3.4.
Description
The auto_split_tablet_size parameter specifies the threshold for triggering automatic partition splitting for a tenant that has enabled automatic partition splitting.
Privilege requirements
Query the parameter
Both the
systenant and user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to query the parameter.Modify the parameter
Both the
systenant and user tenants can execute theALTER SYSTEM SETstatement to modify the parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 2 GB
NoteFor OceanBase Database V4.3.5, the default value is changed from 128 MB to 2 GB starting from V4.3.5 BP3. |
| Value range | [128M, +∞) |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The parameter takes effect after you modify it. |
Considerations
You can execute the ALTER SYSTEM SET statement to modify the parameter.
When you create or modify a table, if the table has enabled automatic partition splitting but does not specify a threshold for automatic partition splitting, the value of this parameter is used as the threshold for automatic partition splitting for the table. When the disk usage of a partition exceeds the threshold specified by this parameter, the partition is split.
Notice
Modifying this parameter does not affect automatically partitioned tables that have been created.
Examples
Set the split threshold to 256 MB.
AlTER SYSTEM SET auto_split_tablet_size = '256MB';