Note
- For OceanBase Database V4.3.x, this parameter was introduced in OceanBase Database V4.3.1.
- For OceanBase Database V4.2.x, this parameter was introduced in OceanBase Database V4.2.1 BP3.
Description
max_partition_num specifies the maximum number of partitions allowed in MySQL mode.
Applicability
This parameter is applicable to only OceanBase Database in MySQL mode.
Limitations
Query the parameter
In the
systenant or a user tenant, you can execute theSHOW PARAMETERSstatement to query the parameter or query theGV$OB_PARAMETERSview for the parameter.Modify the parameter
You can modify the parameter only in the
systenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 8192 |
| Value range | [8192, 65536] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No |
Examples
Set the maximum number of partitions allowed in MySQL mode to 8192.
obclient> ALTER SYSTEM SET max_partition_num=8192;