講解一個經過高手優化的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 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