mysql 5.7 my.inf 文件的解释和提高性能的设置

[client]

#default-character-set = utf8

port = 3306

socket = /home/abc/mysql_data/data/mysql.sock

[mysqld]

default-time-zone = ‘+8:00’

character_set_server = utf8

user = abc

port = 3306

socket = /home/abc/mysql_data/data/mysql.sock

basedir = /usr/local/mysql

datadir = /home/abc/mysql_data/data

log-error = /home/abc/mysql_data/data/mysql_error.log

pid-file = /home/abc/mysql_data/data/mysql.pid

table_definition_cache = 15000

open_files_limit = 65535

innodb_open_files = 65535

table_open_cache = 15000

back_log = 600

#MySQL允许最大连接数

max_connections = 512

#可以允许多少个错误连接

max_connect_errors = 6000

#使用–skip-external-locking MySQL选项以避免外部锁定。该选项默认开启

external-locking = FALSE

max_allowed_packet = 32M

#属重点优化参数</