程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> 講解一個經過高手優化的MySQL數據庫實例

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

編輯: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

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved