当前位置:首页 > 开发 > 数据库 > 正文

MySQL5.6的my.ini配置

发表于: 2015-06-09   作者:aigo   来源:转载   浏览:
摘要: 注意:以下配置的服务器硬件是:8核16G内存    [client]   port=3306   [mysql]   default-character-set=utf8     [mysqld]   port=3306   basedir=D:/mysql-5.6.21-win

注意:以下配置的服务器硬件是: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

MySQL5.6的my.ini配置

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号