讲解一个经过高手优化的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