...
Memory tuning parameters
In the Kyvos 2023.5 release, we have smartness to configure configurations for Heap, Off-heap and other required memory on Query Engines automatically has been automated if the memory mode is set to Auto mode. User needs to perform below steps in case they want to use Kyvos Analytical store Steps to enable For more details, see the Kyvos Java options page in Kyvos Manager.
To enable Kyvos Analytical store, perform the following steps.
Login to Kyvos Manager and navigate to Properties > queryengine.properties Search properties
In the queryengine.properties, search for the DS_CONNECTION_CONF property.
Default The default value will be Blank
Set this value as SET memory_limit='10GB'; SET THREADS to 1; and then save it.
Restart the Query Engine services from the Kyvos Manager dashboard.
For manual memory modeconfiguration, perform the following post-deployment steps.
Open the Kyvos Java options page in Kyvos Manager and Navigate to the Query Engine section.
If Configure Heap memory for Query Engine is set as Auto, no need to change anythingis required.
If
...
Configure Heap memory
...
for Query Engine is set as Manual, reduce
...
Off-Heap memory by 10 GB.
For Example,
...
Suppose the
...
total machine memory is 128 GB,
...
whereas 45 GB is assigned to Heap, and 66 GB is assigned to Off-Heap.
...
In that case, you need to set Heap as 45 GB and Off-Heap as 56 GB so
...
Kyvos can use the remaining 10 GB internally for the new data store-based architecture.