据说这是高手优化的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/yourlanguagedirectory
#slowquerylog#=
#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
#TrynumberofCPU's*2forthread_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
