xSQL Miscellaneous Parameters

The xSQL configuration file can be used to define parameters that determine eXtremeDB runtime operation.

For an overview see page Configuration File Parameters

These parameters consist of "name : value" pairs that can appear anywhere in the configuration file outside of other sections. For example:

 
    db_params : {
        mem_page_size : 256,
        disk_page_size : 4096,
        db_max_connections : 100,
        ...
    }
     
    recovery_enabled : true,
     
    free_memory_threshold : 4m,
    ...
     

The following table lists the possible options:

Option name : example value	Comment
database_name : "mydbname",	The database name to be created (opened) in conventional or shared memory, string
recovery_enabled : true,	Run sniffer to cleanup a shared memory database, boolean
free_memory_threshold : 4m,	Threshold to abort the current transaction if amount of free memory becomes lower. Unsigned, default 1Mb
local_client : "dbname",	An existing shared-memory database name to connect to (as opposed to a remote connection via SQL client - see page xSQL SQL Parameters for further details), string
event_log : xsql.log	Name of event log file or 'stderr'