mysql 16g 内存_mysql配置 8核16G内存

[client]

port=3306

[mysql]

default-character-set=utf8

[mysqld]

port=3306

basedir=H:/dev_env/mysql-5.6.44-winx64

datadir=H:/dev_env/mysql-5.6.44-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 = H:/dev_env/mysql-5.6.44-winx64/log/binlog/mysql-bin.log

log_bin_index = H:/dev_env/mysql-5.6.44-winx64/log/binlog/mysql-bin.index

log_error = H:/dev_env/mysql-5.6.44-winx64/log/mysql-error.log

sync_binlog = 1

expire_logs_days = 7

binlog_format = MIXED

[mysqldump]

max_allowed_packet = 1G