mcsGetConfig for MariaDB Enterprise ColumnStore

MariaDB Enterprise ColumnStore includes the mcsGetConfig utility, which gets configuration parameters from Columnstore.xml.

Reference material is available for MariaDB Enterprise ColumnStore.

MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server.

USAGE

The syntax for the mcsGetConfig utility is:

$ mcsGetConfig [OPTION ...] SECTION PARAMETER

The supported sections and parameters are shown in Columnstore.xml, which is located in /etc/columnstore/ by default.

DETAILS

The mcsGetConfig utility gets configuration parameters from Columnstore.xml, which is located in /etc/columnstore/ by default.

mcsSetConfig is a related utility that sets configuration parameters in Columnstore.xml.

mcsGetConfig Options by MariaDB Enterprise ColumnStore Version

Choose a version of MariaDB Enterprise ColumnStore to see the options supported by that version:

EXAMPLES

Get Mandatory Utility User Account

To get the configuration parameters for the mandatory utility user account:

$ sudo mcsGetConfig CrossEngineSupport Host
$ sudo mcsGetConfig CrossEngineSupport Port
$ sudo mcsGetConfig CrossEngineSupport User
$ sudo mcsGetConfig CrossEngineSupport Password

Get Memory Limit for Joins

To get the memory limit for joins:

$ mcsGetConfig HashJoin PmMaxMemorySmallSide

Get Disk-Based Join Configuration

To get the configuration parameters for disk-based joins:

$ mcsGetConfig HashJoin AllowDiskBasedJoin
$ mcsGetConfig HashJoin TempFileCompression
$ mcsGetConfig HashJoin TempFilePath