| Parameter | Description | Recommended value/range |
|---|---|---|
| memory_chunk_cache_size | The size of 2M memory blocks in the Observer cache. | The default value is 0. We recommend that you keep the default value. |
| memory_limit_percentage | The proportion of OceanBase Database to total system memory. | Increase the memory available to OceanBase Database. |
| memstore_limit_percentage | The maximum percentage of MemStore memory in the tenant memory, which is non-exclusive. | Set this parameter to a sufficiently large value. An excessively large MemStore memory may cause the data writing speed to overrun the minor compaction speed and increase the risk of memory overflow. |
| freeze_trigger_percentage | The threshold for triggering a minor compaction. | We recommend that you keep the default value. |
| system_memory | The memory size reserved for the SYS500 tenant. | We recommend that you use the default value. |
| use_large_pages | Specifies whether to enable large memory pages. | The large memory pages feature takes effect only when it is enabled on the OS side. We recommend that you enable this feature to improve the query efficiency of memory page tables. |
| writing_throttling_trigger_percentage | Performs write throttling when write pressure is high. | The default value is 60. In performance scenarios, you can disable this feature as needed. If disabled, there may be a risk of insufficient memory when write concurrency is very high. |
Memory-related parameters
share
Previous topic