據說這是高手優化的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
