MySQL 之效能調校篇
系統預設值[code]
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
[/code]
修改 my.cnf 設定檔
[code]
[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
[/code]
頁:
[1]