[iyinet]

Genckolik´isimli üyeden Alıntı

SistemBilgisi : Amd 2800 1536 Ram

Top Çıktısı:
top - 23:23:29 up 1 day, 5:57, 1 user, load average: 7.75, 9.88, 13.66
Tasks: 183 total, 9 running, 174 sleeping, 0 stopped, 0 zombie
Cpu(s): 89.5% us, 10.2% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.3% hi, 0.0% si
Mem: 1554768k total, 1400188k used, 154580k free, 88852k buffers
Swap: 2088440k total, 122812k used, 1965628k free, 559792k cached

Mevcut Kullandığım my.cnf:
[mysqld]
set-variable = max_connections=400
safe-show-database
query_cache_size=64M
connect_timeout=5
thread_cache=100
thread_concurrency=120
thread_stack=512000
key_buffer_size=512K
sort_buffer_size=100K
read_buffer_size=100K
max_allowed_packet=64M

Bunlar İlgili Tavsiye Edebileceğiniz ekleri veya düzenlemeleri yazarsanız sevinirim.

Genckolik bir dene bakalim:

[mysqld]
max_connections=400
safe-show-database
query_cache_size=64M
query_cache_limit=1M
query_cache_type=1
table_cache=1024
connect_timeout=5
key_buffer=256M
max_allowed_packet=64M