my.cnf推荐配置

[client]

port = 3306

socket = /tmp/mysql.sock

 

[mysqld]

port = 3306

socket = /tmp/mysql.sock

max_connections=1024

event_scheduler=ON

# 跳过名称解析可以提高远程访问速度

skip-name-resolve

default-storage-engine=INNODB

#最大值是1GB

max_allowed_packet=256M

group_concat_max_len=200000

innodb_log_file_size=1024M

innodb_log_buffer_size=8M