首页 > 代码库 > T端mysql优化设置

T端mysql优化设置

2024-07-06 03:12:02   223人阅读

下面是一个我自己用的设置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


联系
我们