mcsGetConfig for MariaDB Enterprise ColumnStore 23.10

Overview

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

Reference material is available for MariaDB Enterprise ColumnStore 23.10.

MariaDB Enterprise ColumnStore 23.10 is included with MariaDB Enterprise Server 10.6.

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 for MariaDB Enterprise ColumnStore 23.10

Option

Description

-a

display all configuration values

-c

config_file use config file config_file

-h

display this help text

-i

display all configuration values in .ini-file format (implies -a)

-v

display verbose information

To see options supported in other versions, see "mcsGetConfig Options by MariaDB Enterprise ColumnStore 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