mcsSetConfig for MariaDB Enterprise ColumnStore 1.5
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Enterprise ColumnStore 1.5
Topics on this page:
Overview
MariaDB Enterprise ColumnStore 1.5 includes the mcsSetConfig utility, which sets configuration parameters in Columnstore.xml.
Reference material is available for MariaDB Enterprise ColumnStore 1.5.
MariaDB Enterprise ColumnStore 1.5 is included with MariaDB Enterprise Server 10.5.
USAGE
The syntax for the mcsSetConfig utility is:
$ mcsSetConfig [OPTION ...] SECTION PARAMETER VALUE
The supported sections and parameters are shown in Columnstore.xml, which is located in /etc/columnstore/ by default.
With multi-node MariaDB Enterprise ColumnStore 1.5, the mcsSetConfig utility should be executed on the primary server.
Note
Please do not change ColumnStore configuration parameters in Columnstore.xml unless you have been directed to make the change by MariaDB Engineering or the documentation. Incorrect settings can render your system unusable. If you have any questions about ColumnStore configuration, please contact MariaDB Support.
DETAILS
The mcsSetConfig utility sets configuration parameters in Columnstore.xml, which is located in /etc/columnstore/ by default.
mcsGetConfig is a related utility that gets configuration parameters from Columnstore.xml.
mcsSetConfig Options for MariaDB Enterprise ColumnStore 1.5
Option | Description |
|---|---|
config_file use config file config_file | |
don't perform misc checks and don't try to distribute the config file after changes are made | |
display this help text | |
display verbose information | |
delete the param from section (value is still required but ignored) |
To see options supported in other versions, see "mcsSetConfig Options by MariaDB Enterprise ColumnStore Version".
EXAMPLES
Set Mandatory Utility User Account
To set the configuration parameters for the mandatory utility user account:
$ sudo mcsSetConfig CrossEngineSupport Host 127.0.0.1
$ sudo mcsSetConfig CrossEngineSupport Port 3306
$ sudo mcsSetConfig CrossEngineSupport User cross_engine
$ sudo mcsSetConfig CrossEngineSupport Password cross_engine_passwd
Set Memory Limit for Joins
To set the memory limit for joins:
$ mcsSetConfig HashJoin PmMaxMemorySmallSide 1GB
Set Disk-Based Join Configuration
To set the configuration parameters for disk-based joins:
$ mcsSetConfig HashJoin AllowDiskBasedJoin Y
$ mcsSetConfig HashJoin TempFileCompression Y
$ mcsSetConfig HashJoin TempFilePath /mariadb/tmp