mysql生产基本配置

[client]
socket =/home/mysql/mysql-5.7.20/mysql.sock

[mysqld]

basedir=/home/mysql/mysql-5.7.20
datadir=/home/mysql/mysql_data
character-set-server=utf8
collation-server=utf8_general_ci
wait_timeout=120

max_connections=1000

interactive_timeout=300
lower_case_table_names=1
port = 3306
socket=/home/mysql/mysql-5.7.20/mysql.sock
#join_buffer_size = 128M
#sort_buffer_size = 2M
#read_rnd_buffer_size = 2M
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

 

log-error=/home/mysql/mysql_log/mysqld.log

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

group_concat_max_len = 1024000

init_connect='SET NAMES utf8'

skip-name-resolve