Note
This parameter is introduced since OceanBase Database V1.4.
Description
memory_limit_percentage specifies the percentage of available memory to total memory in the OBServer node.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 80 |
| Value range | [10, 95]
NoteThe value range is changed from [10, 90] to [10, 95] since OceanBase Database V4.2.1. |
| Modifiable | Yes. It can be modified using the ALTER SYSTEM SET statement. |
| Effective upon OBServer node restart | No |
Considerations
If the value of memory_limit is not 0, the system will ignore the setting of memory_limit_percentage and prioritize the value configured in memory_limit. For detailed information on memory_limit, see memory_limit.
Examples
obclient> ALTER SYSTEM SET memory_limit_percentage='80';