my.cnf_8.0
免费下载
[client]
port = 3307
socket = /home/mysql/mysqldb/run/mysql.sock
default-character-set = utf8mb4
#prompt = \\u@\\h:\\d \\r:\\m:\\s >
no-auto-rehash
[mysql]
port = 3307
socket = /home/mysql/mysqldb/run/mysql.sock
default-character-set = utf8mb4
prompt = \\u@\\h:\\d \\r:\\m:\\s >
no-auto-rehash
[mysqld]
server-id = 207
port = 3307
default_storage_engine = InnoDB
character_set_server = utf8mb4
binlog_format = ROW
transaction_isolation = READ-COMMITTED
max-allowed-packet = 512M
max-connections = 1000
max-connect-errors = 1000000
datadir = /home/mysql/mysqldb/data
log_bin = /home/mysql/mysqldb/binlogs/mysql-bin
socket = /home/mysql/mysqldb/run/mysql.sock
pid-file = /home/mysql/mysqldb/run/mysql.pid
log_error = /home/mysql/mysqldb/logs/error.log
slow_query_log_file = /home/mysql/mysqldb/logs/slow.log
tmpdir = /home/mysql/mysqldb/tmp
innodb_buffer_pool_size = 20G
innodb_log_file_size = 1G
innodb_log_files_in_group = 5
innodb_data_file_path = ibdata1:500M;ibdata2:500M:autoextend
innodb_temp_data_file_path = ibtmp1:500M;ibtmp2:500M:autoextend:max:5120M
innodb_flush_method = O_DIRECT
default-time-zone = '+8:00'
gtid_mode = ON
enforce_gtid_consistency = ON
binlog_checksum = NONE
log_slave_updates = 1
relay_log_info_repository = TABLE
master_info_repository = TABLE
binlog_expire_logs_seconds = 2592000
# 默认使用 mysql_native_password 插件认证
default_authentication_plugin = mysql_native_password
slow-query-log = 1
long_query_time = 1
#read-only = 1
#
#plugin_load_add = 'group_replication.so'
#group_replication_group_name = 'ec9566ae-5bb7-11ea-b099-cb85388b10ae'
#group_replication_start_on_boot = off
#group_replication_local_address = "dbcluster207:33071"
#group_replication_group_seeds =
"dbcluster207:33071,dbcluster208:33071,dbcluster205:33071"
#group_replication_bootstrap_group=off
of 2
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论