Note
- This parameter was introduced in OceanBase Database V4.2.3. Due to the optimization of the group commit feature in OceanBase Database V4.2.5, this parameter is no longer applicable and has been deprecated since OceanBase Database V4.2.5.
Description
enable_kv_group_commit specifies whether to enable group commit.
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 in the
systenant or a user tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | False |
| Value range | True: Group commit is enabled. The server will group operations based on the execution plan and execute the operations by group.False: Group commit is disabled. The server will execute the operations one by one. |
| 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. |
Examples
Enable group commit.
obclient> ALTER SYSTEM SET enable_kv_group_commit=True;