50 lines
1.8 KiB
Plaintext
50 lines
1.8 KiB
Plaintext
[mysqld]
|
||
skip-host-cache
|
||
skip-name-resolve
|
||
skip_ssl
|
||
datadir=/var/lib/mysql
|
||
secure-file-priv=/var/lib/mysql-files
|
||
collation-server=utf8_bin
|
||
character-set-server=utf8
|
||
init_connect='set names utf8'
|
||
user=mysql
|
||
port=3306
|
||
max_connections=2000
|
||
group_concat_max_len=102400
|
||
max_allowed_packet=256M
|
||
#symbolic-links=0
|
||
log-bin=mysql-bin
|
||
server-id=1 #主库server-id为1,备库server-id为2
|
||
binlog_format=row
|
||
relay-log-purge=0
|
||
#read_only=1 #备库配置
|
||
#log-slave-updates=true #备库配置
|
||
#skip-slave-start=1 #备库配置
|
||
binlog-ignore-db=mysql
|
||
replicate-ignore-db=mysql
|
||
####半自动同步+GTID
|
||
gtid-mode=on
|
||
enforce-gtid-consistency=1
|
||
plugin-load=rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_sla ve.so
|
||
rpl_semi_sync_master_enabled = 1
|
||
rpl_semi_sync_master_timeout = 2000
|
||
rpl_semi_sync_slave_enabled = 1
|
||
################### Slow Log ######################
|
||
slow_query_log = ON
|
||
# 开启慢查询日志
|
||
slow_query_log_file = /var/log/mysql/slow.log
|
||
# 慢查询日志存放路径
|
||
long_query_time = 10
|
||
# 超过10秒的查询，记录到慢查询日志，默认值10
|
||
log_queries_not_using_indexes = ON
|
||
# 没有使用索引的查询，记录到慢查询日志，可能引起慢查询日志快速增长
|
||
log_slow_admin_statements = ON
|
||
# 执行缓慢的管理语句，记录到慢查询日志
|
||
# 例如 ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE T ABLE, and REPAIR TABLE.
|
||
################### Error Log ####################
|
||
log_error = /var/log/mysql/error.log
|
||
# 错误日志存放路径
|
||
log_error_verbosity = 2
|
||
# 全局动态变量，默认3，范围：1～3
|
||
# 表示错误日志记录的信息，1：只记录error信息；2：记录error和warnings信息；3：记录err or、warnings和普通的notes信息
|