mysql配置文件生产环境参数配置

vi /etc/my.cnf

##### /etc/mysql/my.cnf                   ####
###  Part 1 basic settings                   ###
###  Part 2 logsettings                     ###
###  Part 3 replication settings               ###
###  Part 4 innodb settings                  ###

[mysql]
prompt=(\u@\h) [\d]>
max_allowed_packet             = 64M
no_auto_rehash

[mysqld]
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=10000
rpl_semi_sync_slave_enabled=1
########basic settings########

server-id = 1620
port = 3306
user = mysql
socket = /data/3306/mysql.sock
autocommit = 1
character_set_server=utf8mb4
skip_name_resolve = 1
max_connections = 2048
max_user_connections=300
max_connect_errors = 10
open_files_limit=65565
innodb_open_files=2048

#init-connect=