Here is a standalone setup that I use to set up MySQL's Secure World of Warcraft.
This is set for 2-4g memory. Increase the throughput of MySQL. To achieve the stability of MySQL, so that many people play in the game when not due to MySQL caused by the card
[Client]
port=3306 [mysqld] port=3306old-passwords=1basedir= "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= utf8default-collation=utf8_general_ci skip-locking### #方法 (2) key_buffer Cancel Key_buffer_size =32Mkey_buffer = 256mkey_buffer_size = 256mmax_allowed_packet = 4msort_buffer_size = 2mnet_buffer_length = 1024Kread_buffer_size = 2Mread _rnd_buffer_size = 2mjoin_buffer_size = 2mtable_cache = 500thread_cache_size=1024thread_concurrency = 8max_connections = 300max_user_connections=350thread_stack = 128k long_query_time = 5max_heap_table_size = 32Mtmp_table_size = 32mquery_cache_size = 32m wait_timeout=57600interactive_timeout = 28800connect_timeout = 30back_log=300 Innodb_file_per_tableinnodb_thread_concurrency=8innodb_flush_log_at_trx_commit=0innodb_buffer_pool_size = 512minnodb_additional_mem_pool_size = 50minnodb_autoextend_increment = 8innodb_log_buffer_size = 10Minnodb_opeN_files = 500innodb_table_locks=0[mysql]no-auto-rehash [mysqlhotcopy]interactive_timeout