MySQL 之效能調校篇

bestlong

系統預設值

1. join_buffer_size   =   131,072 = 128K
   
2. key_buffer_size    = 8,388,600 =   8M
   
3. max_allowed_packet = 1,048,576 =   1M
   
4. query_cache_size   =         0 =   0K
   
5. read_buffer_size   =   131,072 = 128K
   
6. sort_buffer_size   = 2,097,144 =   2M
   
7. table_cache        =        64

複製代碼

修改 my.cnf 設定檔

1. [mysqld]
   
2. join_buffer_size=10M
   
3. key_buffer_size=64M
   
4. max_allowed_packet=2M
   
5. query_cache_size=32M
   
6. read_buffer_size=1M
   
7. sort_buffer_size=4M
   
8. table_cache=256

複製代碼