[client]
port=3308
max_allowed_packet=1G
plugin-dir=C:/Program Files/MariaDB 10.2/lib/plugin

[mysqld]

#######################################
# to run as a service needs this:
#"C:\Program Files\MariaDB 10.2\bin\mysqld.exe" "--defaults-file=c:\etc\MySQL\my.ini" "MySQL"
# so configure it like this
#sc create "MariaDB" binpath= "\"C:/Program Files/MariaDB 10.2/bin/mysqld.exe\" \"--defaults-file=C:/etc/MySQL/my.ini\" MariaDB" DisplayName= "MariaDB" start= "demand"
#sc description MariaDB "MariaDB 10.2 database server"
#######################################

#######################################
# global settings
#######################################
datadir							=	d:/db/MariaDB/data/
tmpdir							=	d:/db/MariaDB/tmp/
port							=	3308
event-scheduler					=	on
server_id						=	105
gtid_domain_id					=	105
thread-pool-min-threads			=	8
optimizer-switch				=	'exists_to_in=on'
sql_mode						=	"STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
userstat						=	1
performance-schema          	
#character-set-server			=	utf8mb4
max_allowed_packet				=	1G
#max_connections				=	250
                            	
#skip_name_resolve				=	on
                            	
#wait_timeout					=	14400
#interactive_timeout				=	14400

# default is 1M >= 10.2.4
#group_concat_max_len			=	8192

#table_open_cache_size
#table_definitions_cache_size
#open_files_limit
table_open_cache_instances		=	16

#######################################
# binary log settings
#######################################
log_bin							=	mysql-bin
log_bin_index					=	mysql-bin.index
expire_logs_days				=	2
binlog-format					=	MIXED
sync-binlog						=	0

#######################################
# log settings
#######################################
log-output						=	table
log-warnings                	

#######################################
# innodb settings
#######################################
#innodb_fast_shutdown			=	1
#innodb_force_recovery			=	6
innodb_log_file_size			=	2G
innodb_log_buffer_size			=	16M
innodb_file_per_table			=	on
innodb_flush_log_at_trx_commit	=	1
innodb_buffer_pool_size			=	16G
innodb_buffer_pool_instances	=	8
innodb_page_cleaners			=	8
innodb_read_io_threads			=	16
innodb_write_io_threads			=	16
innodb_background_scrub_data_uncompressed	=	on

#innodb_file_format				=	barracuda
#innodb_compression_algorithm	=	zlib
#innodb_use_mtflush				=	off
#innodb_mtflush_threads			=	8
innodb_lru_scan_depth			=	256
innodb_flush_method				=	O_DIRECT
innodb_purge_threads			=	8
innodb_thread_concurrency		=	8
innodb_stats_on_metadata		=	off

#innodb_io_capacity				=	600
#innodb_io_capacity_max				=	1000
innodb_io_capacity				=	25000
innodb_io_capacity_max			=	30000

innodb_buffer_pool_dump_at_shutdown	=	on
innodb_buffer_pool_load_at_startup	=	on
innodb_buffer_pool_dump_pct			=	100

innodb_checksum_algorithm		=	crc32

# set to 0 for SSD otherwise 1
innodb_flush_neighbors			=	0

#######################################
# aria settings
#######################################
query_cache_size				=	0
query_cache_type				=	off


#######################################
# encryption settings
#######################################
plugin-load-add					=	file_key_management
file-key-management
file-key-management-filename		=	z:/config/mariadb_master_key
file_key_management_encryption_algorithm	=	aes_cbc
innodb-encrypt-tables				=	force
#innodb-encryption-threads			=	4
innodb_default_encryption_key_id	=	1
innodb-encrypt-log					=	on
aria-encrypt-tables					=	on
encrypt-tmp-disk-tables				=	on
encrypt-binlog						=	on

#######################################
# data scrubbing
#######################################
#innodb_background_scrub_data_check_interval	= 3600

##### end #############################