Note
This parameter was introduced in OceanBase Database V4.3.4.
Description
The kv_group_commit_batch_size parameter specifies the size of batch operations in group commit. When the value is 1, group commit is disabled. Otherwise, group commit is enabled and the value specifies the size of each commit batch.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to view the parameter value.Modify the parameter
The
systenant and user tenants can modify the parameter value.
Attributes
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 1
NoteFor OceanBase Database V4.3.5, the default value was changed from 1 to 10 starting from V4.3.5 BP1. |
| Value range | (0, +∞) |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify the parameter value. |
| Effective upon OBServer node restart | No. The parameter value takes effect immediately after it is set. |
Examples
Set the group commit batch size to 10.
obclient> ALTER SYSTEM SET kv_group_commit_batch_size = 10;