mysql 5.7 的 /etc/my.cnf 参数详解数据库

下面是 mysql 5.7 的 /etc/my.cnf 的一些常用参数，自己记录一下，随时补充完善。

[client] 

port = 3306 

default-character-set=utf8mb4 

socket=/var/lib/mysql/mysql.sock 

[mysql] 

port = 3306 

default-character-set=utf8mb4 

socket=/var/lib/mysql/mysql.sock 

[mysqld] 

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

# summary 

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

bind-address = 0.0.0.0 

port = 3306 

basedir=/usr/local/mysql 

datadir=/var/lib/mysql 

socket=/var/lib/mysql/mysql.sock 

tmpdir = /tmp 

pid-file=/tmp/mysqld.pid 

#skip-grant-tables 

#skip-networking 

explicit_defaults_for_timestamp=1 

lower_case_table_names=1 

table_open_cache = 8000 

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

# time out 

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

connect_timeout = 20 

wait_timeout = 86400 

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

# connection 

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

max_connections = 2000 

max_user_connections = 1900 

max_connect_errors = 100000 

max_allowed_packet = 1G 

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

# character set 

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

character-set-server = utf8mb4 

collation-server = utf8mb4_bin 

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

# log bin 

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

server-id = 1 

log_bin = mysql-bin 

binlog_format = MIXED 

sync_binlog = 1 

expire_logs_days =7 

binlog_cache_size = 128m 

max_binlog_cache_size =512m 

max_binlog_size =256M 

binlog_ignore_db=mysql 

binlog_ignore_db=information_schema 

binlog_ignore_db=performation_schema 

binlog_ignore_db=sys 

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

# log relay 

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

relay_log = mysql-relay-bin 

relay_log_purge = on 

relay_log_recovery = on 

max_relay_log_size = 1G 

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

# log error 

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

log_error=/var/log/mysqld_error.log 

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

# log slow 

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

slow_query_log = on 

slow_query_log_file = /var/log/mysqld_slow.log 

long_query_time = 2 

log_queries_not_using_indexes = on 

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

# log general 

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

general_log = on 

general_log_file = /var/log/mysqld_gener.log 




 
原创文章，作者：Maggie-Hunter，如若转载，请注明出处：https://blog.ytso.com/3891.html
 

 mysql