Overview
ob_vector_memory_limit_percentage specifies the memory usage threshold for the vector index module.
Privilege requirements
Query parameters
Both the
systenant and user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0, in percentage.
NoteThe default value of this parameter indicates adaptive mode, where the system automatically adjusts the memory usage ratio for vector index data within a tenant:
|
| Value range | [0, 100). The actual maximum value is85 - Memstore(That is,memstore_limit_percentage(value). Whenmemstore_limit_percentageThe parameter is set to0When this parameter is set to the default value, the system automatically calculates the memory usage of the MemStore. The calculation rules are as follows:
|
| 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
Memory calculation
The specific values for this parameter need to be planned based on the calculation formula and business requirements. Please click Download memory calculation table to calculate the parameter values.
Table description:
When you need to create multiple vector indexes under one tenant, the required memory is the sum of all their memory requirements.
You need to fill in the values for the number of data records in the first column and the vector dimensionality in the second column based on your business scenario.
The third column of the table, M, indicates the maximum number of edges in the HNSW graph index. The default value is
16, which usually does not need to be changed.The minimum memory configuration in the fifth column of the table applies only to scenarios where indexes are created later and no new data is added.
Increase the memory usage of vector indexes
If you need to increase the threshold for vector index memory usage, it is recommended to first reduce the MemStore memory usage of that tenant. This can be achieved by modifying the _memstore_limit_percentage parameter under the user tenant.
Notice
Reducing the MemStore ratio may impact DML performance. Therefore, in environments with high DML workload, be sure to evaluate the impact before making changes.
Configuration example
Set the memory usage threshold for vector indexes to 30%.
obclient> ALTER SYSTEM SET ob_vector_memory_limit_percentage = 30;
Increase the memory usage threshold for vector indexes to 59%.
obclient> ALTER SYSTEM SET _memstore_limit_percentage = 25;
ALTER SYSTEM SET ob_vector_memory_limit_percentage = 59;
View the current memory configuration for vector indexes.
obclient> SHOW PARAMETERS LIKE 'ob_vector_memory_limit_percentage';