mysql学习之参数配置

--mysql参数部分
[mysql]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8
prompt = \\u@\\h:\\d \\r:\\m:\\s >

[mysqld]
log-bin=mysql-bin
socket=/tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /u01/mysql/mysql5722
log-error=/usr/local/mysql/log/mysql.log
pid-file=/usr/local/mysql/mysql.pid
sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

#-----info2------
log-bin-index=mysql-bin.index
binlog-format=row
binlog-row-image=full
sync_binlog=1
innodb_flush_log_at_trx_commit=1
innodb_flush_method=O_DIRECT
max_allowed_packet=52m
open_files_limit=65535
#------info2-------
port = 3306
default-storage-engine = InnoDB
character-set-server = utf8
binlog_format = ROW
transaction_isolation = READ-COMMITTED
max-allowed-packet = 512M
max-connections = 3000
max-connect-errors = 1000000
sysdate-is-now = 1
server-id = 1
innodb-buffer-pool-size = 20G
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 3
innodb-log-file-size = 1G
log_timestamps = SYSTEM
expire-logs-days = 15
slow-query-log = 1
slow-query-log-file = /u01/mysql/mysql5722/mysql_slow.log
explicit_defaults_for_timestamp = 1
innodb_temp_data_file_path = ibtmp1:200M;ibtmp2:200M:autoextend:max:5120M

gtid_mode = ON
enforce_gtid_consistency = 1
log_slave_updates = 1
default-time-zone = '+8:00'
relay_log_info_repository = TABLE
master_info_repository = TABLE
# 开启MySQL5.7的并行复制功能，减少主从延迟
slave-parallel-type = LOGICAL_CLOCK
slave-parallel-workers = 4
relay_log_recovery = 1
lower_case_table_names=1
max_connections=3000
#skip-grant-tables