T端mysql优化设置

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