MySQL5.6安装参数文件的示例分析-创新互联
这篇文章主要介绍MySQL5.6安装参数文件的示例分析,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!
成都创新互联坚持“要么做到,要么别承诺”的工作理念,服务领域包括:网站设计制作、成都网站设计、企业官网、英文网站、手机端网站、网站推广等服务,满足客户于互联网时代的沽源网站设计、移动媒体设计的需求,帮助企业找到有效的互联网解决方案。努力成为您成熟可靠的网络建设合作伙伴!# MySQL_version 5.6.26
# Version 1.1
# Date 2016-03-31
# The MySQL server
[mysqld]
port = 5626
user = my5626
datadir = /data/mysql5626
tmpdir = /dev/shm
slave-load-tmpdir = /tmp
socket = /tmp/mysql5626.sock
key_buffer_size = 128M
max_allowed_packet = 16M
#table_cache = 2048
join_buffer_size = 16M
sort_buffer_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 128M
query_cache_size = 256M
query_cache_limit = 8M
max_tmp_tables = 256
tmp_table_size = 128M
max_heap_table_size = 128M
thread_cache_size = 64
thread_concurrency = 32
max_connect_errors = 99999999
long_query_time = 1
slow-query-log = 1
slow-query-log-file = slow.log
back_log = 600
myisam_repair_threads = 1
myisam_recover_options = force,backup
expire_logs_days = 10
interactive_timeout = 30
wait_timeout = 30
#old_passwords=1
skip-slave-start = 1
skip-name-resolve
max_user_connections = 4000
max_connections = 5000
character-set-server = utf8
read_only = 1
log-slave-updates = 0
#------------- innodb --------------
default-storage-engine = InnoDB
innodb_buffer_pool_size = 5G
innodb_additional_mem_pool_size = 32M
innodb_data_file_path = ibdata1:100M:autoextend
innodb_flush_log_at_trx_commit = 0
innodb_log_buffer_size = 8M
innodb_log_file_size = 1300M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 20
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_support_xa = 0
innodb_io_capacity = 500
innodb_buffer_pool_instances = 10
server-id = 016205624
log-bin = mysql-bin
relay-log = relay-bin
log-error = error.log
[client]
user = mysqlha
password = xxx
port = 5626
socket = /tmp/mysql5626.sock
no-auto-rehash
[myisamchk]
key_buffer = 64M
sort_buffer_size = 32M
read_buffer = 16M
write_buffer = 16M
以上是“MySQL5.6安装参数文件的示例分析”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注创新互联-成都网站建设公司行业资讯频道!
名称栏目:MySQL5.6安装参数文件的示例分析-创新互联
当前URL:http://pwwzsj.com/article/cshsoi.html