#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
bind_address=0.0.0.0
binlog_expire_logs_seconds=10800
binlog_format=ROW
connect_timeout=60
cracklib_password_check=OFF
datadir=/data10/mysql
default_storage_engine=innodb
general_log=OFF
general_log_file=/data11/mysql/logs/mysqld.log
gtid_domain_id=11
gtid_strict_mode=ON
idle_transaction_timeout=600
innodb_autoinc_lock_mode=2
innodb_buffer_pool_size=192G
innodb_change_buffering=NONE
innodb_data_file_path=ibdata1:12M:autoextend
innodb_data_home_dir=/data10/mysql
innodb_file_per_table=ON #Default
innodb_flush_log_at_trx_commit=1
innodb_io_capacity=2000
innodb_io_capacity_max=20000
innodb_log_buffer_size=64M
innodb_log_file_size=48G
innodb_log_group_home_dir=/data01/mysql
innodb_print_all_deadlocks=ON
innodb_undo_directory=/data10/mysql
innodb_undo_log_truncate=ON #Default
innodb_undo_tablespaces=1
interactive_timeout=300
log_basename=mariadb
log_bin=/data01/mysql/mariadb-binary-log #GTID mode
log_bin_index=/data01/mysql/mariadb-binary-log.index #GTID mode
log_error=/data11/mysql/logs/mysqld.log
log_queries_not_using_indexes=ON
log_slave_updates=ON #Primary to replica and GTID mode
log_slow_filter=admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk #Default
log_slow_verbosity=query_plan,explain
log_warnings=2
long_query_time=10.0
max_connections=256
min_examined_row_limit=10000
#performance_schema=ON #Resource intensive
pid_file=/data10/mysql/mysql.pid
#relay_log=mariadb-relay-log #Primary to replica
#relay_log_basename=/data01/mysql #Primary to replica
#relay_log_info_file=mariadb-relay-log.info #Primary to replica
#relay_log_purge=ON #Primary to replica
server_id=1
session_track_state_change=ON #causal reads
session_track_system_variables=autocommit,character_set_client,character_set_connection,character_set_results,last_gtid,time_zone #causal reads
session_track_transaction_info=CHARACTERISTICS #causal reads
skip_name_resolve=TRUE
#slave_parallel_mode=minimal #Primary to replica
#slave_parallel_max_queued=131072 #Primary to replica
#slave_parallel_threads=20 #Primary to replica
#slave_skip_errors=1062 #Primary to replica
slow_query_log=ON
slow_query_log_file=/data11/mysql/logs/mysqld-slow-query.log
socket=/data10/mysql/mysql.sock
thread_cache_size=256
thread_handling=pool-of-threads
#thread_pool_oversubscribe=3 #Default is 3 per thread group (per CPU)
thread_pool_size=16
transaction_isolation=READ-COMMITTED
#sync_binlog=0 #Primary to replica
#sync_relay_log=0 #Primary to replica
wait_timeout=600

[mysqld_safe]
open_files_limit=32768

[client]
socket=/data10/mysql/mysql.sock

[mariadb]
aria_log_dir_path=/data10/mysql
#userstat=ON