[client]
port                                     = 3310
socket                                   = /engn001/masvc01/mysql/mysqld.sock

default-character-set                    = utf8

[mysqld_safe]
socket                                   = /engn001/masvc01/mysql/mysqld.sock
nice                                     = 0


[mariadb]
plugin-load-add                          = ha_connect.so


###########################################
[mysqld]
# -- Auditing - pre-load Plugin
plugin-load                              = server_audit

pid-file                                 = /engn001/masvc01/mysql/mysqld.pid
socket                                   = /engn001/masvc01/mysql/mysqld.sock
port                                     = 3310
basedir                                  = /engn001/masvc01/mysql
datadir                                  = /data001/masvc01
tmpdir                                   = /logs001/masvc01/data
autocommit                               = 0

init_connect                             = SET collation_connection = utf8_bin
init_connect                             = SET NAMES utf8
character_set_server                     = utf8
collation-server                         = 'utf8_bin'



#
# * Common
#

skip-name-resolve
max-allowed-packet                       = 1G
open-files-limit                         = 65535
max-connect-errors                       = 100000
max-connections                          = 500
thread-cache-size                        = 2000
back-log                                 = 1024
max-heap-table-size                      = 36M
sql-mode                                 = STRICT_TRANS_TABLES,PIPES_AS_CONCAT
lower_case_table_names                   = 1
log_bin_trust_function_creators          = 1
table-definition-cache                   = 10240
table-open-cache                         = 10240
transaction-isolation                    = READ-COMMITTED
performance_schema
event_scheduler                          = 1

read_rnd_buffer_size                     = 48M
sort_buffer_size                         = 48M
read_buffer_size                         = 48M
tmp-table-size                           = 1G
join-buffer-space-limit                  = 48M
join-cache-level                         = 6
join-buffer-size                         = 48M

# Query Cache
query-cache-size                         = 0
query-cache-type                         = 0

#Replication
server-id                                = 2
slave_parallel_threads                   = 8
gtid_domain_id                           = 1
relay-log                                = /logs001/masvc01/relay/mysqld-relay-bin


# Security
symbolic-links                           = 0
local-infile                             = 1


# Logging
log-warnings                             = 2
log-error                                = /logs001/masvc01/error/mysqld.err



sql_error_log_filename                   = /logs001/masvc01/error/sql_errors.log
sql_error_log_rate                       = 1
sql_error_log_rotate                     = 1
sql_error_log_rotations                  = 9
sql_error_log_size_limit                 = 104857600

slow-query-log                           = 1
long-query-time                          = 3
log-slow-verbosity                       = 'query_plan,explain'
slow_query_log_file                      = /logs001/masvc01/slow/mariadb-slow.log

#  Binlog File

#binlog-annotate-row-events               = OFF
#log_bin                                  = /logs001/masvc01/binary/mariadb-bin
#log_bin_index                            = /logs001/masvc01/binary/mariadb-bin.index

#binlog-format                            = MIXED
#expire-logs-days                         = 7
#max-binlog-size                          = 1024M


#
# * Aria
#
#aria_pagecache_buffer_size              = 4M
#aria_sort_buffer_size                   = 4M
#aria_group_commit                       = 1
#aria_group_commit_interval              = 100
#aria_block_size                         = 8KB
#aria_used_for_temp_tables               = 1




# InnoDB
default-storage-engine                   = 'InnoDB'

innodb_data_home_dir                     = /data001/masvc01
innodb_data_file_path                    = ibdata1:3072M;ibdata2:3072M;ibdata3:3072M;ibdata4:3072M:autoextend

innodb-stats-on-metadata                 = 0
innodb-stats-sample-pages                = 32
# To be set to 0 if not multi transactional storage engine
innodb-support-xa                        = ON
innodb_large_prefix                      = 1
innodb-buffer-pool-instances             = 4
#innodb-buffer-pool-size                  = 24G
innodb-buffer-pool-size                  = 40G
innodb-max-dirty-pages-pct               = 50
innodb-file-per-table                    = 1
innodb-file-format                       = Barracuda
innodb-flush-log-at-trx-commit           = 1
innodb_flush_method                      = O_DIRECT
innodb-log-buffer-size                   = 1024M
innodb-log-files-in-group                = 3
innodb-log-file-size                     = 1024M
innodb-open-files                        = 8192
innodb-read-io-threads                   = 12
innodb-write-io-threads                  = 12
innodb_print_all_deadlocks               = 1
innodb_show_verbose_locks                = 1
innodb_lock_wait_timeout                 = 100

#innodb buffer dump
innodb_buffer_pool_dump_at_shutdown      = 1
innodb_buffer_pool_load_at_startup       = 1
innodb_buffer_pool_load_now              = 1
innodb_buffer_pool_dump_now              = 1

# -- Set the value for incremental backup
#innodb_log_archive                      = 1
#innodb_log_arch_dir                     = /logs001/masvc01/archive
#innodb_log_arch_expire_sec              =
#innodb_track_changed_pages              = 1

#innodb_force_recovery = 1

# MyISAM
key-buffer-size                          = 24M
flush                                    = OFF
myisam-recover-options                   = BACKUP,FORCE
myisam-sort-buffer-size                  = 24M

# Other
# -- Enable INFORMATION_SCHEMA.%_STATISTICS tables
userstat                                 = ON
#archive                                  = OFF
#blackhole                                = OFF
#federated                               = OFF
#innodb                                  = FORCE

[mysql]
default-character-set                    = 'utf8'
auto-rehash                              = FALSE
local-infile                             = 1
max-allowed-packet                       = 1G
secure-auth                              = TRUE

[mysqldump]
max-allowed-packet                       = 1G
default-character-set                    = 'utf8'

[myisamchk]
key-buffer-size                          = 1G
sort-buffer-size                         = 1G
read-buffer-size                         = 8M
write-buffer-size                        = 8M