Overview
memstore_limit_percentage specifies the percentage of a tenant's total available memory that can be used by the MemStore.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | INT |
| Default Value | 0 indicates adaptive adjustment. |
| Value range | 0, 100) |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
The
memstore_limit_percentageparameter is used to calculate the value ofmemstore_limit. The calculation formula is as follows:memstore_limit_percentage=memstore_limit/memory_sizeHere,
memory_sizeis the value specified when creating the tenant, representing the memory available for the tenant.You can also configure the percentage of memory occupied by a tenant's MemStore from the total memory of the tenant by using the tenant-level hidden parameter
_memstore_limit_percentage. Except for the scope of application, its functionality and default value are the same as those of the cluster-level parametermemstore_limit_percentage. When configuring these two parameters, note the following:- If only one of the parameters
_memstore_limit_percentageormemstore_limit_percentageis configured with a value other than the default, that value will be used. - If both the tenant-level hidden parameter
_memstore_limit_percentage(with a value other than the default) and the cluster-level parametermemstore_limit_percentage(with a value other than the default) are configured, the value of_memstore_limit_percentagewill be used. - If neither is configured, or if both are configured with the default values, the system will use the following adaptive policy:
- Tenants with 8 GB or less of memory (real memory) will have their tenant MemStore configured at 40%.
- Tenants with more than 8 GB of memory will have their tenant MemStore configured at 50%.
- If only one of the parameters
Configuration example
Set the memory for the tenant's MemStore to 60% of its total available memory.
obclient> ALTER SYSTEM SET memstore_limit_percentage = 60;
References
- [Minor compaction and major compaction
- Modify minor compaction settings
- Tenant memory full
- Memory management within a tenant