2gb安装mysql8_[转载]服务器72G内存 My.cnf配置参考

#Mysql Configuration for 72G menory

[client]

port = 3306

socket = /tmp/mysql.sock

#the mysql server

[mysqld]

server-id = 1

port = 3306

basedir = /...

datadir = /...

socket = /tmp/mysql.sock

skip-external-locking

skip-name-resolve

default-storage-engine = INNODB

character-set-server = utf8

wait_timeout = 100

connect_timeout = 20

interactive_timeount = 100

back_log = 500

myisam_recover

event_scheduler = ON

###################binlog#########################

log-bin = /xxx/mysql-bin

binlog_format = row

max_binlog_size = 128M

binlog_cache_size = 2M

expire-logs-day = 5

###################replication###################

slave-net-timeout