Note
Since the memory management feature corresponding to MemStore is no longer used in V4.x, this parameter is removed starting from V4.2.0.
Description
global_write_halt_residual_memory specifies the percentage of the remaining memory threshold. When the remaining memory is lower than this percentage, write operations of ordinary tenants are paused.
Note
The value of this parameter does not affect the sys tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 30 |
| Value range | (0, 100) |
| 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. |
Considerations
The percentage of global_write_halt_residual_memory is based on memory_limit - system_memory, which excludes the memory reserved for the 500 tenant in OceanBase Database. When calculating the remaining memory, the memory occupied by BlockCache is considered as the memory available to MemStore.
Examples
Set the percentage of the remaining memory threshold to 30.
obclient> ALTER SYSTEM SET global_write_halt_residual_memory=30;