講解一個經過高手優化的MySQL數據庫實例

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

You May Also Like