The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Configuration settings

Hi, I want to know about some system configuration variables for fine tuning. There are a lot of configuration parameters in Columnstore.xml file such as DebugLevel, DataFileLog, TransactionArchivePeriod, and so on. There are explanations about NumBlocksPct and TotalUmMemory,PrefetchThreshold, etc. in Knowledge Base on https://mariadb.com/kb/en/mariadb/mariadb-columnstore-performance-related-configuration-settings/ However, It doesn't contain everything.

Where can I find additional information about configuration variables(Columnstore.xml, my.cnf)? Do you have any other documents? Thank you very much!

Answer Answered by David Thompson in this comment.

The article you reference covers the most important settings related to performance. The other ones are system generated by postConfigure and are normally best to play with and may take you out of configurations we test and validate. Over time we'll open these up but in general columnstore is decided to work fairly optimally out of the box with not too much configuration.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.