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
my.conf
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
Kod:
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
Kod:
[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