mcsGetConfig for MariaDB Enterprise ColumnStore
This page is part of MariaDB's Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Enterprise ColumnStore
Topics on this page:
Overview
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