Note
This parameter was introduced in OceanBase Database V1.4.
Description
memory_limit_percentage specifies the percentage of available memory to total memory on an OBServer node.
Privilege requirements
Query the parameter
You can query the parameter by using the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview in thesystenant and all user tenants.Modify the parameter
You can modify the parameter only in the
systenant. User tenants cannot modify the parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 80 |
| Value range | [10, 95]
NoteThe value range has been changed from [10, 90] to [10, 95] since OceanBase Database V4.2.1. |
| 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
If the value of memory_limit is not 0, the system ignores the setting of memory_limit_percentage and prioritizes the value of memory_limit. For more information about memory_limit, see memory_limit.
Example
Set the percentage of available memory to total memory on an OBServer node to 80%.
obclient> ALTER SYSTEM SET memory_limit_percentage='80';