MySQL5.7初始化配置文件模板

Rock Yan

1192

1页

40次

2020-03-08

免费下载

[mysql]

port = 3306

socket = /data/mysql/run/mysql.sock

default-character-set = utf8

prompt = \\u@\\h:\\d \\r:\\m:\\s >

[client]

default-character-set = utf8

[mysqld]

port = 3306

default-storage-engine = InnoDB

character-set-server = utf8

socket = /data/mysql/run/mysql.sock

pid-file = /data/mysql/run/mysql.pid

binlog_format = ROW

transaction_isolation = READ-COMMITTED

max-allowed-packet = 512M

max-connections = 1000

max-connect-errors = 1000000

server-id = 1

datadir = /data/mysql/data

log-bin = /data/mysql/binlogs/mysql-bin

innodb-buffer-pool-size = 10G

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

innodb_data_file_path = ibdata1:300M;ibdata2:300M:autoextend

innodb_temp_data_file_path = ibtmp1:300M;ibtmp2:300M:autoextend:max:5120M

innodb_undo_directory = /data/mysql/undologs

innodb_undo_tablespaces = 5

log-error = /data/mysql/logs/error.log

slow-query-log-file = /data/mysql/logs/slow.log

tmpdir = /data/mysql/tmp

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

#半同步设置

#rpl_semi_sync_master_enabled = 1

#rpl_semi_sync_slave_enabled = 1

[mysql]

port = 3306

socket = /data/mysql/run/mysql.sock

default-character-set = utf8

prompt = \\u@\\h:\\d \\r:\\m:\\s >

[client]

default-character-set = utf8

[mysqld]

port = 3306

default-storage-engine = InnoDB

character-set-server = utf8

socket = /data/mysql/run/mysql.sock

pid-file = /data/mysql/run/mysql.pid

binlog_format = ROW

transaction_isolation = READ-COMMITTED

max-allowed-packet = 512M

max-connections = 1000

max-connect-errors = 1000000

server-id = 1

datadir = /data/mysql/data

log-bin = /data/mysql/binlogs/mysql-bin

innodb-buffer-pool-size = 10G

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

innodb_data_file_path = ibdata1:300M;ibdata2:300M:autoextend

innodb_temp_data_file_path = ibtmp1:300M;ibtmp2:300M:autoextend:max:5120M

innodb_undo_directory = /data/mysql/undologs

innodb_undo_tablespaces = 5

log-error = /data/mysql/logs/error.log

slow-query-log-file = /data/mysql/logs/slow.log

tmpdir = /data/mysql/tmp

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

#半同步设置

#rpl_semi_sync_master_enabled = 1

#rpl_semi_sync_slave_enabled = 1

of 1

免费下载

mysql 安装部署特别推荐

关注

评论