bestlong 怕失憶論壇
標題:
MySQL 之效能調校篇
[打印本頁]
作者:
bestlong
時間:
2006-9-28 13:40
標題:
MySQL 之效能調校篇
系統預設值
join_buffer_size = 131,072 = 128K
key_buffer_size = 8,388,600 = 8M
max_allowed_packet = 1,048,576 = 1M
query_cache_size = 0 = 0K
read_buffer_size = 131,072 = 128K
sort_buffer_size = 2,097,144 = 2M
table_cache = 64
複製代碼
修改 my.cnf 設定檔
[mysqld]
join_buffer_size=10M
key_buffer_size=64M
max_allowed_packet=2M
query_cache_size=32M
read_buffer_size=1M
sort_buffer_size=4M
table_cache=256
複製代碼
歡迎光臨 bestlong 怕失憶論壇 (http://www.bestlong.idv.tw/)
Powered by Discuz! X1.5