Configuring Memurai SQL · Memurai Docs

Configuration file

Memurai SQL configuration is done through a configuration text file, which follows the Valkeyconfiguration format [key value]. You create the configuration text file, for example configfile.txt, add the values for the specific configuration that you want, and then save to the Memurai installation folder.

Set the following properties in the configuration file:

num_threads: thread pool size for the compute operations. The minimum number is 4, default is ALL cores available in the server.
metadata_persistence: enables the persistence of metadata. Set the value as either ON or OFF, the default is OFF. For more information about the metadata persistence setting, see Metadata Persistence.

Example configuration

The following is an example Memurai SQL configuration in config file format.

num_threads 8
metadata_persistence ON

Enabling the Memurai SQL configuration

Load the configuration file as an argument of the module load command for Memurai SQL. For example,

On Windows:

C:\>memurai-cli module load C:\somepath\memurai-sql.dll configfile.txt

On Linux:

$ valkey-cli module load /somepath/libmemurai-sql.so configfile.txt

If no configuration file is specified when starting Memurai SQL, the default settings are used.