[client]
socket=/tmp/maria.sock

[mysqld]
#user=root
user=mysql
bind-address=0.0.0.0
#basedir = /MARIA/mariadb ##removed 260716
#sql-mode=ANSI_QUOTES,STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
port=3621
socket=/tmp/maria.sock
pid-file=/data/data/mysql.pid
datadir=/data/data/DATA
tmpdir=/data/data/tmp
innodb_data_home_dir=/data/data/DATA
innodb_log_group_home_dir=/data/data/DATA
lower_case_table_names=1
#plugin_dir = /MARIA/mariadb/lib/plugin ##removed 260716
event_scheduler=ON
innodb_strict_mode=OFF
default_storage_engine=InnoDB

# Character set Config
character-set-client-handshake=FALSE
character-set-server=utf8mb4
init_connect=SET collation_connection = utf8mb4_bin
init_connect=SET NAMES utf8mb4
collation_server=utf8mb4_bin

##columnstore_use_import_for_batchinsert = ALWAYS

# Common Config
back_log=1024
binlog_cache_size=1M
ft_min_word_len=4
interactive_timeout=28800
join_buffer_size=2M
max_allowed_packet=1024M
max_heap_table_size=1024M
max_connections=2048
performance_schema
read_buffer_size=2M
read_rnd_buffer_size=2M
skip-external-locking
skip-name-resolve=1
sort_buffer_size=2M
max_length_for_sort_data=1024
tmp_table_size=1024M
table_open_cache=10240
table_definition_cache=10240
transaction-isolation=READ-COMMITTED
open_files_limit=65535

# Query Cache Disable
query_cache_type=0
query_cache_size=0

# Log Config
log-bin=/data/maria_log/binary/mysql-bin
relay-log=/data/maria_log/relay/relay-log
expire_logs_days=3
max_binlog_size=1G
sync_binlog=1
binlog_format=row
relay_log_purge=1
log_slave_updates=1
log-error=/data/maria_log/error/mysql.err
slow_query_log_file=/data/maria_log/slow/mysql-slow-query.log
slow_query_log=1
long_query_time=2
#general_log=1
#general_log_file=/data/maria_log/general/mysql_general.log

# InnoDB Config
#innodb_buffer_pool_size=96G
innodb_buffer_pool_size=192G ##modified 260724
innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G:autoextend
innodb_file_per_table=1
#innodb_flush_method=O_DIRECT
innodb_flush_method=fsync
innodb_lock_wait_timeout=15
innodb_log_buffer_size=512M
innodb_log_file_size=1024M
#innodb_thread_sleep_delay=0
#innodb_log_files_in_group=4
innodb_fast_shutdown
innodb_autoinc_lock_mode=1
#innodb_thread_concurrency=0
innodb_read_io_threads=32
innodb_write_io_threads=32
innodb_open_files=8192
innodb_io_capacity=10000
innodb_io_capacity_max=20000
#innodb_force_recovery=1

# MyISAM Config
bulk_insert_buffer_size=64M
key_buffer_size=128M
myisam_max_sort_file_size=10G
myisam_recover_options
myisam_repair_threads=1
myisam_sort_buffer_size=64M

# Thread pool
thread_handling=pool-of-threads
thread_pool_stall_limit=60
thread_pool_idle_timeout=120

## Password check
#simple_password_check=OFF
#simple_password_check_digits=0
#simple_password_check_letters_same_case=0
#simple_password_check_minimal_length=0
#simple_password_check_other_characters=0

# Required for Schema Sync
server-id=1
#log_bin
#optimizer_switch='rowid_filter=off' ##removed 260716
#disable-log-bin
slave_connections_needed_for_purge=0 ##added 260716

## ColumnStore
plugin-load-add=ha_columnstore.so
#columnstore_um_mem_limit=16384 ##added 260819
columnstore_um_mem_limit=32768 ##added 260826

[mysqldump]
quick
max_allowed_packet=1024M