当前位置:Gxlcms > mysql > 经过高手优化的MySQL数据库实例_MySQL

经过高手优化的MySQL数据库实例_MySQL

时间:2021-07-01 10:21:17 帮助过:21人阅读

 据说这是高手优化的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

人气教程排行