经过高手优化的MySQL数据库实例

kider

　　据说这是高手优化的MySQL,供大家参考,其中连接数: max_connections=1500可以根据服务器的性能更改.

#set-variable = connect_timeout=5 #set-variable = wait_timeout=5

　　建议启用,负担重的服务器可以适当减少持续连接时间
　

[mysqld] 　　basedir=D:/mysql 　　#bind-address=ip 　　datadir=D:/mysql/data 　　#language=D:/mysql/share/your language directory 　　#slow query log#= 　　#tmpdir#= 　　#port=3306 　　set-variable = max_connections=1500 　　skip-locking 　　#skip-networking 　　set-variable = key_buffer=384M 　　set-variable = max_allowed_packet=1M 　　set-variable = table_cache=512 　　set-variable = sort_buffer=2M 　　set-variable = record_buffer=2M 　　set-variable = thread_cache=8 　　# Try number of CPU's*2 for thread_concurrency 　　set-variable = thread_concurrency=8 　　set-variable = myisam_sort_buffer_size=64M 　　#set-variable = connect_timeout=5 　　#set-variable = wait_timeout=5 　　server-id = 1 　　[isamchk] 　　set-variable = key_buffer=128M 　　set-variable = sort_buffer=128M 　　set-variable = read_buffer=2M 　　set-variable = write_buffer=2M 　　[myisamchk] 　　set-variable = key_buffer=128M 　　set-variable = sort_buffer=128M 　　set-variable = read_buffer=2M 　　set-variable = write_buffer=2M 　　[WinMySQLadmin] 　　Server=D:/mysql/bin/mysqld-nt.exe