Optimizasyon önerileriniz

[SeVeRaL]

Merhaba arkadaşlar.
P4 2.4 GHZ, 1 GB RAM, CentOs özellikli sunucum için my.cnf ve diğer optimizasyon önerilerinizi bekliyorum.
Sunucum biraz yoğun bu aralar. Yoğun saatlerde mysql ve apache down oluyor. Plesk bunları otomatik olarak restart'lıyor. Mysql konfigürasyonu yapmak istiyorum.

top -c

top - 15:31:10 up 19 min,  1 user,  load average: 2.39, 1.85, 1.21
Tasks: 298 total,   1 running, 297 sleeping,   0 stopped,   0 zombie
Cpu(s): 76.1% us, 23.3% sy,  0.0% ni,  0.0% id,  0.0% wa,  0.7% hi,  0.0% si
Mem:   1027556k total,   972772k used,    54784k free,     1928k buffers
Swap:  2000084k total,     3104k used,  1996980k free,   270816k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 2862 mysql     15   0  552m  98m 4468 S 65.6  9.9   1:50.97 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr -
 3293 apache    15   0 27424  10m 4172 S  8.6  1.1   0:00.94 /usr/sbin/httpd
14053 apache    15   0 25696 9124 3800 S  7.9  0.9   0:00.57 /usr/sbin/httpd
 7664 apache    15   0 28044 9412 3988 S  1.0  0.9   0:00.28 /usr/sbin/httpd
 9566 apache    16   0 27616  11m 4072 S  1.0  1.1   0:02.86 /usr/sbin/httpd
16077 apache    15   0 25428 8784 3800 S  1.0  0.9   0:00.04 /usr/sbin/httpd
 2940 root      15   0  6568 4252  464 S  0.6  0.4   0:03.54 floodkoruma -i eth0 -f tcp[tcpflags] & tcp-syn != 0 and dst port
 8930 apache    15   0 27760  11m 4056 S  0.6  1.1   0:00.46 /usr/sbin/httpd
12638 apache    15   0 28184  11m 4072 S  0.6  1.2   0:00.42 /usr/sbin/httpd
14077 apache    16   0 25328 7824 2860 S  0.6  0.8   0:00.10 /usr/sbin/httpd
14084 apache    15   0 25660 9132 3872 S  0.6  0.9   0:00.16 /usr/sbin/httpd
14109 apache    15   0 27892  11m 4020 S  0.6  1.1   0:00.35 /usr/sbin/httpd
14590 apache    15   0 25624 9104 3864 S  0.6  0.9   0:00.17 /usr/sbin/httpd
15419 apache    15   0 25236 7596 2724 S  0.6  0.7   0:00.35 /usr/sbin/httpd
15497 apache    16   0 25268 7552 2748 S  0.6  0.7   0:00.06 /usr/sbin/httpd
15511 apache    15   0 25548 8012 2880 S  0.6  0.8   0:00.05 /usr/sbin/httpd
15992 root      17   0  3464 1100  760 R  0.6  0.1   0:00.16 top -c
 2598 named     18   0 37428 2576 1796 S  0.3  0.3   0:00.36 /usr/sbin/named -u named -c /etc/named.conf -u named -t /var/nam
 3118 apache    15   0 27096  10m 4064 S  0.3  1.0   0:00.51 /usr/sbin/httpd
 5338 apache    15   0 27608  11m 4060 S  0.3  1.1   0:00.70 /usr/sbin/httpd
 8511 apache    16   0 27416  10m 4028 S  0.3  1.1   0:00.34 /usr/sbin/httpd
 8885 apache    16   0 25624 9080 3872 S  0.3  0.9   0:00.27 /usr/sbin/httpd
 9974 apache    15   0 27836  10m 3236 S  0.3  1.0   0:00.58 /usr/sbin/httpd
10880 apache    15   0 25652 9012 3820 S  0.3  0.9   0:00.24 /usr/sbin/httpd
10881 apache    16   0 25600 9016 3808 S  0.3  0.9   0:00.16 /usr/sbin/httpd
11194 apache    15   0 26128 9700 4016 S  0.3  0.9   0:00.25 /usr/sbin/httpd
11714 apache    15   0 28256  10m 3184 S  0.3  1.1   0:00.50 /usr/sbin/httpd
11767 apache    16   0 25192 7468 2704 S  0.3  0.7   0:00.13 /usr/sbin/httpd
11786 apache    15   0 27924  11m 4072 S  0.3  1.1   0:00.40 /usr/sbin/httpd
12658 apache    15   0 25328 7700 2808 S  0.3  0.7   0:00.10 /usr/sbin/httpd
12690 apache    16   0 25224 8596 3800 S  0.3  0.8   0:00.10 /usr/sbin/httpd
12714 apache    15   0 25592 9012 3864 S  0.3  0.9   0:00.16 /usr/sbin/httpd
14032 apache    15   0 25608 9004 3804 S  0.3  0.9   0:00.18 /usr/sbin/httpd
14113 apache    15   0 25256 8764 3908 S  0.3  0.9   0:00.08 /usr/sbin/httpd
14298 apache    15   0 27544  10m 4000 S  0.3  1.1   0:00.26 /usr/sbin/httpd
14591 apache    15   0 25348 7868 2876 S  0.3  0.8   0:00.05 /usr/sbin/httpd
15379 apache    15   0 25180 7596 2840 S  0.3  0.7   0:00.09 /usr/sbin/httpd

my.conf

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
key_buffer = 384M
table_cache = 512
max_allowed_packet=64M
wait_timeout = 3600
query_cache_size=32M
query_cache_type=1
max_connections=300
init-connect="SET NAMES latin5"

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=latin5
default-collation=latin5_turkish_ci

[Remark]

aynı sıkıntı bendede var acaba yardımcı olabilecek arkadaşlar varmı

[MoD]

@Remark asagidaki basligi incelersen yardimi olacaktir. Kendi verilerini yazabilirsin.
http://forum.iyinet.com/mysql-verita...mizasyonu.html