mysql5.7.27的配置文件解析

一、

二、公司的my.cnf

[universe]
bakupdir = /data/mysql/backup/3306
group_id = mysql-superapp_kfc 
iops = 0
mem_limit_mb = 0
cpu_quota_percentage = 0
quota_limit_mb = 0
scsi_pr_level = 0 
umask_dir = 0750
umask = 0640
mycnf = /data/mysql/etc/3306/my.cnf 
run_user = actiontech-mysql 
id = mysql-64xsxk 

[mysqld]
super_read_only = 1 

# DO NOT MODIFY, Universe will generate this part 
port = 3306 
server_id = 1518178936
basedir = /data/mysql/base/5.7.25 
datadir = /data/mysql/data/3306 
log_bin = /data/mysql/log/binlog/3306/mysql-bin 
tmpdir = /data/mysql/tmp/3306 
relay_log = /data/mysql/log/relaylog/3306/mysql-relay 
innodb_log_group_home_dir = /data/mysql/log/redolog/3306
log_error = /data/mysql/data/3306/mysql-error.log 
report_host = 172.21.13.21

# BINLOG
binlog_error_action = ABORT_SERVER
binlog_format = row 
binlog_rows_query_log_events = 1
log_slave_updates = 1 
master_info_repository = TABLE
max_binlog_size = 250M
relay_log_info_repository = TABLE 
relay_log_recovery = 1
sync_binlog = 1 

# GTID #
gtid_mode = ON
enforce_gtid_consistency = 1

# ENGINE
default_storage_engine = InnoDB 
innodb_buffer_pool_size = 100G
innodb_data_file_path = ibdata1:1G:autoextend 
innodb_file_per_table = 1 
innodb_flush_log_at_trx_commit=1
innodb_flush_method = O_DIRECT
innodb_io_capacity = 1000 
innodb_log_buffer_size = 64M
innodb_log_file_size = 2G 
innodb_log_files_in_group = 2 
innodb_max_dirty_pages_pct = 60 
innodb_print_all_deadlocks=1
innodb_stats_on_metadata = 0
innodb_strict_mode = 1
#innodb_undo_logs=128 #Deprecated In 5.7.19 
#innodb_undo_tablespaces=3 #Deprecated In 5.7.21
innodb_max_undo_log_size=4G 
innodb_undo_log_truncate=1
innodb_read_io_threads = 8
innodb_write_io_threads = 8 
innodb_purge_threads = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1 
innodb_buffer_pool_dump_pct=25
innodb_sort_buffer_size = 8M
#innodb_page_cleaners = 8 
#innodb_buffer_pool_instances = 8 
innodb_monitor_enable = log_lsn_checkpoint_age,log_max_modified_age_async,log_max_modified_age_sync 

# CACHE 
key_buffer_size = 32M 
tmp_table_size = 32M
max_heap_table_size = 32M 
table_open_cache = 1024 
query_cache_type = 0
query_cache_size = 0
max_connections = 8000
thread_cache_size = 1024
open_files_limit = 65535
binlog_cache_size = 1M
join_buffer_size = 8M 
sort_buffer_size = 8M 

# SLOW LOG
slow_query_log = 1
slow_query_log_file = /data/mysql/data/3306/mysql-slow.log
log_slow_admin_statements = 1 
log_slow_slave_statements = 1 
long_query_time= 1

# SEMISYNC #
plugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so" 
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_slave_enabled = 0 
rpl_semi_sync_master_wait_for_slave_count = 1 
rpl_semi_sync_master_wait_no_slave = 0
rpl_semi_sync_master_timeout = 300000 # 5 minutes 

# CLIENT_DEPRECATE_EOF
session_track_schema = 1
session_track_state_change = 1
session_track_system_variables = '*'

# MISC
log_timestamps=SYSTEM 
lower_case_table_names = 1
max_allowed_packet = 64M
read_only = 1 
skip_external_locking = 1 
skip_name_resolve = 1 
skip_slave_start = 1
socket = /data/mysql/data/3306/mysqld.sock
pid_file = /data/mysql/data/3306/mysqld.pid 
disabled_storage_engines = ARCHIVE,BLACKHOLE,EXAMPLE,FEDERATED,MEMORY,MERGE,NDB 
log-output = TABLE,FILE 
character_set_server = utf8mb4
secure_file_priv = "" 
performance-schema-instrument='wait/lock/metadata/sql/mdl=ON' 
expire_logs_days = 5

# MTS 
slave-parallel-type=LOGICAL_CLOCK 
slave_parallel_workers=16 
slave_preserve_commit_order=1 

三、