Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.02.3
-
2023-8
Description
Most of the items in our columnstore.cnf are commented out and many of them are obsolete anyway. This file needs an overhaul and we need to add certain server settings related to Columnstore performance like character_set_server and collation_server that may differ than the server's own defaults.
[mysqld]
|
plugin-load-add=ha_columnstore.so
|
|
|
# Enable compression by default on create, set to NONE to turn off
|
#columnstore_compression_type=SNAPPY
|
|
|
# ColumnStore local query flag
|
#columnstore_local_query=0
|
|
|
#columnstore_diskjoin_smallsidelimit=0
|
#columnstore_diskjoin_largesidelimit=0
|
#columnstore_diskjoin_bucketsize=100
|
#columnstore_um_mem_limit=0
|
|
|
# Required for Schema Sync
|
#server-id = 1
|
#log_bin
|
|
|
# Uncomment for this UM to apply slave DML on ColumnStore tables
|
#columnstore_replication_slave=ON
|
=====New version
[mysqld]
plugin-load-add=ha_columnstore.so
collation_server = utf8_general_ci
character_set_server = utf8
columnstore_use_import_for_batchinsert = ON