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.
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 |
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
obclient> ALTER SYSTEM SET memory_limit_percentage='80';