Note
This parameter was introduced in OceanBase Database V2.2.30.
Description
writing_throttling_maximum_duration specifies the time required for allocating the remaining memory of the MemStore after the write speed is limited. This parameter controls the write speed by controlling the memory allocation progress.
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 | Time |
| Default value | 2h
NoteThe default value is changed from |
| Value range | [1s, 3d] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No |
Examples
Set the time required for allocating the remaining memory of the MemStore after the write speed is limited to 2h.
obclient> ALTER SYSTEM SET writing_throttling_maximum_duration = '2h';
