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.
