下面这个配置在现网服务器上跑了两年了，里面多项参数都有调整过，这个算是最终的一个配置，这个配置不一定适合每种项目，仅供参考。

 

如果MySQL出现异常：Out of memory

需要修改这几个参数：

sort_buffer_size

read_buffer_size

read_rnd_buffer_size

join_buffer_size

max_connections

具体修改方式：

 

注意：以下配置的服务器硬件是：8核16G内存 

 

 

[client]

 

port=3306

 

[mysql]

 

default-character-set=utf8

 

 

[mysqld]

 

port=3306

 

basedir=D:/mysql-5.6.21-winx64

 

datadir=D:/mysql-5.6.21-winx64/data

 

character-set-server=utf8

 

default-storage-engine=INNODB

 

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

max_connections=300

query_cache_size=186M

table_open_cache=1520

tmp_table_size=67M

thread_cache_size=38

myisam_max_sort_file_size=100G

myisam_sort_buffer_size=67M

key_buffer_size=290M

read_buffer_size = 1M

read_rnd_buffer_size = 8M

sort_buffer_size = 1M

innodb_additional_mem_pool_size=80M

innodb_flush_log_at_trx_commit=0

innodb_log_buffer_size=8M

innodb_buffer_pool_size=2G

innodb_log_file_size=1024M

innodb_thread_concurrency=18

innodb_support_xa = 1

innodb_file_per_table = 1

innodb_file_format = Barracuda

#interactive_timeout = 2147482

#wait_timeout = 2147482

interactive_timeout = 86400

wait_timeout = 86400

max_allowed_packet = 1G

 

# binlog

log_bin = D:/mysql-5.6.21-winx64/log/binlog/mysql-bin.log

log_bin_index = D:/mysql-5.6.21-winx64/log/binlog/mysql-bin.index

log_error = D:/mysql-5.6.21-winx64/log/mysql-error.log

sync_binlog = 1

expire_logs_days = 7

binlog_format = MIXED

 

[mysqldump]  

max_allowed_packet = 1G