mysql部署时常用配置_mysql my.cnf常用的配置

[mysqld]

basedir = /usr/local/mysql/

datadir = /usr/local/mysql/data

port = 3306

pid-file = /usr/local/mysql/data/mysql.pid

server-id=1

key_buffer_size= 2G

binlog_format=ROW

log-error = /usr/local/mysql/log/error.log

general_log = 1

general_log_file = /usr/local/mysql/log/general.log

slow_query_log= 1

slow_query_log_file= /usr/local/mysql/log/slow.log

log_bin= /usr/local/mysql/log/mysql-bin

#################################################

user= mysql

max_connections = 1000

open_files_limit = 65535

max_connect_errors = 6000

character_set_server= utf8

explicit_defaults_for_timestamp=true

autocommit= 0

##################################################

[mysql]

default-character-set = utf8

[client]

port=3306

socket=/tmp/mysql.sock