my.cnf ayarları

set-variable = max_connections=600
safe-show-database
local-infile=0
skip-locking # serverda sadece 1 MySQL varsa
skip-name-resolve
max_connections = 600 # cok yogun sitelerde bu deger arttirilabilir
thread_cache_size = 128
key_buffer = 256M
query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 4M
table_cache = 2000 # cok fazla tablolu veritabanlarinda bu deger arttirilabilir
low_priority_updates = 1

### innodb varsa asagidaki ayarlari aciniz
innodb_buffer_pool_size=384M #Innodb kullanimi cok ise 384M, 1024M e kadar arttirilabilir


( Serverdaki my.cnf ayarlarım yukardaki gibidir. Server 8 Gb ram, Processor #1 Vendor: GenuineIntel
Processor #1 Name: unknown
Processor #1 speed: 2736.491 MHz
Processor #1 cache size: 2048 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: unknown
Processor #2 speed: 2736.491 MHz
Processor #2 cache size: 2048 KB

Processor #3 Vendor: GenuineIntel
Processor #3 Name: unknown
Processor #3 speed: 2736.491 MHz
Processor #3 cache size: 2048 KB

Processor #4 Vendor: GenuineIntel
Processor #4 Name: unknown
Processor #4 speed: 2736.491 MHz
Processor #4 cache size: 2048 KB


Makina yukardaki gibidir. my.cnf ayar onerilerinizi bekliyorum.

Saygılar