Note
- This parameter was introduced in OceanBase Database V4.3.4.
- This parameter takes effect only in the OBKV-Table model.
Description
The kv_group_commit_rw_mode parameter specifies whether to perform group commit for read and write operations.
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 | STRING |
| Default value | ALL |
| Valid values |
|
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify the parameter value. |
| Effective after restart of OBServer node | No. The parameter takes effect immediately after it is set. |
Examples
The following example sets the parameter value to READ, indicating that group commit is performed only for read operations.
obclient> ALTER SYSTEM SET kv_group_commit_rw_mode = 'READ' tenant=<tenant_name>;