首页 > 数据库技术 > 详细

T端mysql优化设置

时间:2014-05-27 15:38:18      阅读:571      评论:0      收藏:0      [点我收藏+]

下面是一个我自己用的设置MYSQL的安全的魔兽世界私服的单机设置办法。
这个是针对2-4G内存来设置的。提升MYSQL的吞吐量。实现MYSQL的稳定,让多人在游戏里面玩的时候不至于由于MYSQL而导致很卡
[client]

 
port=3306
 
[mysqld]
 
port=3306
old-passwords=1
basedir="D:\MGCORE-4.1.0-V1.2.1-14007\Web_Mysql\mysql5/"
datadir="D:\MGCORE-4.1.0-V1.2.1-14007\Web_Mysql\mysql5/Data/"
 
default-character-set=utf8
default-collation=utf8_general_ci
 
skip-locking
####方法(2) key_buffer 取消 key_buffer_size =32M
key_buffer = 256M
key_buffer_size = 256M
max_allowed_packet = 4M
sort_buffer_size = 2M
net_buffer_length = 1024K
read_buffer_size = 2M
read_rnd_buffer_size = 2M
join_buffer_size = 2M
table_cache = 500
thread_cache_size=1024
thread_concurrency = 8
max_connections = 300
max_user_connections=350
thread_stack = 128K
 
long_query_time = 5
max_heap_table_size = 32M
tmp_table_size = 32M
query_cache_size = 32M
 
wait_timeout=57600
interactive_timeout = 28800
connect_timeout = 30
back_log=300
 
innodb_file_per_table
innodb_thread_concurrency=8
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 50M
innodb_autoextend_increment = 8
innodb_log_buffer_size = 10M
innodb_open_files = 500
innodb_table_locks=0
[mysql]
no-auto-rehash
 
[mysqlhotcopy]
interactive_timeout

T端mysql优化设置,布布扣,bubuko.com

T端mysql优化设置

原文:http://www.cnblogs.com/needly/p/3753088.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!