range_optimizer_max_mem_size specifies the maximum memory space available for the Query Range module.
Note
This parameter is available since OceanBase Database V4.2.0.
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 128M |
| Value range | [16M, 1G] |
| Effective upon OBServer node restart | No |
This parameter limits the memory usage of the Query Range module. When the memory used by the Query Range module reaches the specified value, the system no longer extracts a query range. For example, if a complex predicate hits an index and the memory used to extract the query range for the predicate reaches the specified value, the system does not select the index and tries to access the primary table.
Example
ALTER SYSTEM SET range_optimizer_max_mem_size = '128M';