pRoFeSSioNaL adlı üyeden alıntı: mesajı görüntüle
abacus hocam ben yanlış anlattım herhalde Ana sunucu 4gb ram işletim sistemi de üstteki..
Benim VPS olduğu için 786 ram var bende ama 1 marttan sonra 1gb ram olacak öyle bir ayar yapalım ki diyorum 1gb'ye göre ayarlayalım.

ayrıca %99'lara vuran ise Memory Load yani RAM kullanımı. server loadda problem yok 0.50 seviyesinde (2 cpus)..

Yani bendeki 786 ram hocam..

Bilgiler doğrultusunda bakabilirseniz çok sevinirim..
-
KeepAlive Off
MaxKeepAliveRequests 50
KeepAliveTimeout 5
UseCanonicalName Off
AccessFileName .htaccess
DefaultType text/plain
HostnameLookups Off
ErrorLog logs/error_log
ServerTokens Full
-
StartServers 8
MinSpareServers 8
MaxSpareServers 18
MaxClients 100
MaxRequestsPerChild 500
-
Timeout 30
ExtendedStatus On
LogLevel warn
ServerSignature On
-


my.cnf
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=128M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=4 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci

Uğraştıyoruz ama bizim için yararlı ellerine kollarına sağlık..
Merhabalar : Maximum gunluk 4-5 k tekil ve 1gb ram icin duzenledim; 

My.cnf :

local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M 
query_cache_type=1
max_connections=300
interactive_timeout=10
wait_timeout=60
connect_timeout=20
thread_cache_size=64
key_buffer=64 
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=128
record_buffer=1M
sort_buffer_size=1M 
read_buffer_size=1M 
read_rnd_buffer_size=1M
thread_concurrency=4
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci

Httpd.conf icin sadece asagidakileri degistirin : 

StartServers 8
    MinSpareServers 5
    MaxSpareServers 20
    MaxClients 156
    MaxRequestsPerChild 1000
iyi calismalar.