Normal zamanlarda 1 i geçmeyen loadım zaman zaman aşırı yükselmeler yapıyor. Bazen br kaç dakika içinde geri iniyor ama bazen 50 - 60 larda takılıp kalıyor. Sorunu bir türlü çözemedik arkadaşlar. Kapattık artık siteleri öyle bekliyoruz. Aranızda bu konularda çok deneyimli arkadaşlar var. Bütün çıktılar aşağıda. Yardımcı olurlarsa sevinirim.
Değerler load yükselmeye geçtiği bir anda alınmıştır.
Server Özellikleri
İşlemci: Intel Core2 Quad Q9300 2.5GHz 1333MHz FSB 6MB Cache
Ram: 8 GB 800 MHz DDR II top -c çıktısı top - 10:11:25 up 17:03, 1 user, load average: 7.91, 4.90, 2.82
Tasks: 151 total, 2 running, 149 sleeping, 0 stopped, 0 zombie
Cpu(s): 31.7% us, 18.3% sy, 0.0% ni, 19.6% id, 29.9% wa, 0.5% hi, 0.0% si
Mem: 8300428k total, 5228212k used, 3072216k free, 440272k buffers
Swap: 5406712k total, 0k used, 5406712k free, 1821468k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3111 root 0 -20 0 0 0 S 56.2 0.0 52:00.33 [loop0]
23375 nobody 24 0 45296 18m 6484 R 30.9 0.2 0:00.98 /usr/local/apache/bin/httpd -k start -DSSL
3594 mysql 15 0 705m 162m 4356 S 22.3 2.0 134:36.64 /usr/sbin/mysqld --basedir=/ --datadir=/var/l
23360 nobody 20 0 49640 23m 7092 S 17.6 0.3 0:00.58 /usr/local/apache/bin/httpd -k start -DSSL
23368 nobody 18 0 47904 21m 6268 S 13.3 0.3 0:00.43 /usr/local/apache/bin/httpd -k start -DSSL
23417 nobody 17 0 43984 16m 5460 S 6.0 0.2 0:00.19 /usr/local/apache/bin/httpd -k start -DSSL
23292 nobody 17 0 45724 20m 7700 S 5.0 0.2 0:00.89 /usr/local/apache/bin/httpd -k start -DSSL
23434 nobody 16 0 46696 19m 5632 S 5.0 0.2 0:00.18 /usr/local/apache/bin/httpd -k start -DSSL
23299 nobody 15 0 45708 19m 7512 S 4.7 0.2 0:00.63 /usr/local/apache/bin/httpd -k start -DSSL
3112 root 16 0 0 0 0 S 3.0 0.0 1:43.30 [kjournald]
23361 nobody 16 0 45288 18m 6468 S 3.0 0.2 0:00.13 /usr/local/apache/bin/httpd -k start -DSSL
23385 nobody 17 0 45288 18m 6468 S 2.7 0.2 0:00.13 /usr/local/apache/bin/httpd -k start -DSSL
23386 nobody 15 0 46688 20m 7152 S 2.7 0.3 0:00.13 /usr/local/apache/bin/httpd -k start -DSSL
23370 nobody 16 0 47148 20m 6944 S 2.3 0.3 0:00.12 /usr/local/apache/bin/httpd -k start -DSSL
23249 nobody 15 0 46868 20m 6784 S 2.0 0.3 0:00.12 /usr/local/apache/bin/httpd -k start -DSSL
23364 nobody 17 0 45064 17m 5956 S 2.0 0.2 0:00.10 /usr/local/apache/bin/httpd -k start -DSSL
23382 nobody 16 0 46364 19m 6076 S 1.7 0.2 0:00.09 /usr/local/apache/bin/httpd -k start -DSSL
23435 nobody 15 0 46364 19m 6076 S 1.7 0.2 0:00.09 /usr/local/apache/bin/httpd -k start -DSSL
23199 nobody 16 0 47312 21m 7680 S 1.3 0.3 0:13.05 /usr/local/apache/bin/httpd -k start -DSSL
23422 nobody 16 0 44508 17m 6148 S 1.3 0.2 0:00.05 /usr/local/apache/bin/httpd -k start -DSSL
23425 nobody 15 0 44508 17m 6148 S 1.3 0.2 0:00.05 /usr/local/apache/bin/httpd -k start -DSSL
23430 nobody 16 0 44768 18m 6468 S 1.3 0.2 0:00.06 /usr/local/apache/bin/httpd -k start -DSSL
23432 nobody 16 0 44508 17m 6148 S 1.3 0.2 0:00.05 /usr/local/apache/bin/httpd -k start -DSSL
23446 nobody 16 0 44508 17m 6124 S 1.3 0.2 0:00.05 /usr/local/apache/bin/httpd -k start -DSSL
23250 nobody 15 0 44908 20m 9216 S 1.0 0.3 0:00.39 /usr/local/apache/bin/httpd -k start -DSSL
23295 nobody 16 0 44176 19m 8280 S 1.0 0.2 0:01.38 /usr/local/apache/bin/httpd -k start -DSSL
23424 nobody 16 0 44508 17m 6152 S 1.0 0.2 0:00.05 /usr/local/apache/bin/httpd -k start -DSSL
23341 nobody 16 0 45324 18m 6032 S 0.7 0.2 0:00.07 /usr/local/apache/bin/httpd -k start -DSSL
23366 nobody 16 0 45324 18m 5960 S 0.7 0.2 0:00.06 /usr/local/apache/bin/httpd -k start -DSSL
23379 nobody 15 0 45816 18m 6516 S 0.7 0.2 0:00.07 /usr/local/apache/bin/httpd -k start -DSSL
23420 nobody 17 0 44004 17m 5912 S 0.7 0.2 0:00.04 /usr/local/apache/bin/httpd -k start -DSSL
23447 nobody 15 0 43728 16m 5364 S 0.7 0.2 0:00.02 /usr/local/apache/bin/httpd -k start -DSSL
23448 nobody 15 0 44248 16m 5556 S 0.7 0.2 0:00.02 /usr/local/apache/bin/httpd -k start -DSSL
11 root 5 -10 0 0 0 S 0.3 0.0 0:11.58 [events/1]
7981 named 18 0 68440 2876 1892 S 0.3 0.0 0:02.38 /usr/sbin/named -u named
ps -aux çıktısı
[
root@server ~]# ps -aux
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 1904 552 ? S Dec26 0:01 init [3]
root 2 0.0 0.0 0 0 ? S Dec26 0:00 [migration/0]
root 3 0.0 0.0 0 0 ? SN Dec26 0:00 [ksoftirqd/0]
root 4 0.0 0.0 0 0 ? S Dec26 0:00 [migration/1]
root 5 0.0 0.0 0 0 ? SN Dec26 0:00 [ksoftirqd/1]
root 6 0.0 0.0 0 0 ? S Dec26 0:00 [migration/2]
root 7 0.0 0.0 0 0 ? SN Dec26 0:00 [ksoftirqd/2]
root 8 0.0 0.0 0 0 ? S Dec26 0:00 [migration/3]
root 9 0.0 0.0 0 0 ? SN Dec26 0:00 [ksoftirqd/3]
root 10 0.0 0.0 0 0 ? S< Dec26 0:00 [events/0]
root 11 0.0 0.0 0 0 ? S< Dec26 0:11 [events/1]
root 12 0.0 0.0 0 0 ? S< Dec26 0:00 [events/2]
root 13 0.0 0.0 0 0 ? S< Dec26 0:03 [events/3]
root 14 0.0 0.0 0 0 ? S< Dec26 0:00 [khelper]
root 15 0.0 0.0 0 0 ? S< Dec26 0:00 [kacpid]
root 40 0.0 0.0 0 0 ? S< Dec26 0:00 [kblockd/0]
root 41 0.0 0.0 0 0 ? S< Dec26 0:00 [kblockd/1]
root 42 0.0 0.0 0 0 ? S< Dec26 0:00 [kblockd/2]
root 43 0.0 0.0 0 0 ? S< Dec26 0:00 [kblockd/3]
root 44 0.0 0.0 0 0 ? S Dec26 0:00 [khubd]
root 63 0.0 0.0 0 0 ? S Dec26 0:00 [kswapd0]
root 64 0.0 0.0 0 0 ? S< Dec26 0:00 [aio/0]
root 65 0.0 0.0 0 0 ? S< Dec26 0:00 [aio/1]
root 66 0.0 0.0 0 0 ? S< Dec26 0:00 [aio/2]
root 67 0.0 0.0 0 0 ? S< Dec26 0:00 [aio/3]
root 211 0.0 0.0 0 0 ? S Dec26 0:00 [kseriod]
root 448 0.0 0.0 0 0 ? S< Dec26 0:00 [ata/0]
root 449 0.0 0.0 0 0 ? S< Dec26 0:00 [ata/1]
root 450 0.0 0.0 0 0 ? S< Dec26 0:00 [ata/2]
root 451 0.0 0.0 0 0 ? S< Dec26 0:00 [ata/3]
root 452 0.0 0.0 0 0 ? S< Dec26 0:00 [ata_aux]
root 458 0.0 0.0 0 0 ? S Dec26 0:00 [scsi_eh_0]
root 459 0.0 0.0 0 0 ? S Dec26 0:00 [scsi_eh_1]
root 467 0.0 0.0 0 0 ? S Dec26 0:00 [scsi_eh_2]
root 468 0.0 0.0 0 0 ? S Dec26 0:00 [scsi_eh_3]
root 471 0.0 0.0 0 0 ? S Dec26 0:00 [scsi_eh_4]
root 472 0.0 0.0 0 0 ? S Dec26 0:00 [scsi_eh_5]
root 512 1.9 0.0 0 0 ? D Dec26 19:59 [kjournald]
root 1134 0.0 0.0 0 0 ? S< Dec26 0:00 [kauditd]
root 1701 0.0 0.0 2032 464 ? S<s Dec26 0:00 udevd
root 1859 0.0 0.0 0 0 ? S< Dec26 0:00 [hda_codec/0]
root 1860 0.0 0.0 0 0 ? S< Dec26 0:00 [hda_codec/1]
root 1861 0.0 0.0 0 0 ? S< Dec26 0:00 [hda_codec/2]
root 1862 0.0 0.0 0 0 ? S< Dec26 0:00 [hda_codec/3]
root 2504 0.0 0.0 0 0 ? S Dec26 0:00 [kjournald]
root 3111 5.0 0.0 0 0 ? S< Dec26 52:00 [loop0]
root 3112 0.1 0.0 0 0 ? S Dec26 1:43 [kjournald]
root 3388 0.0 0.0 3504 524 ? Ds Dec26 0:00 syslogd -m 0
root 3392 0.0 0.0 2580 372 ? Ss Dec26 0:00 klogd -x
root 3405 0.0 0.0 3040 288 ? Ss Dec26 0:02 irqbalance
root 3414 0.0 0.0 2568 300 ? S Dec26 0:00 /usr/sbin/courierlogger -pid=/var/spool/aut
root 3415 0.0 0.0 3632 604 ? S Dec26 0:00 /usr/libexec/courier-authlib/authdaemond
root 3445 0.0 0.0 3632 252 ? S Dec26 0:00 /usr/libexec/courier-authlib/authdaemond
root 3446 0.0 0.0 3632 252 ? S Dec26 0:00 /usr/libexec/courier-authlib/authdaemond
root 3447 0.0 0.0 3632 252 ? S Dec26 0:00 /usr/libexec/courier-authlib/authdaemond
root 3448 0.0 0.0 3632 252 ? S Dec26 0:00 /usr/libexec/courier-authlib/authdaemond
root 3449 0.0 0.0 3632 252 ? S Dec26 0:00 /usr/libexec/courier-authlib/authdaemond
root 3490 0.0 0.0 2928 428 ? Ss Dec26 0:00 /usr/sbin/acpid
root 3538 0.0 0.0 4860 1156 ? Ss Dec26 0:00 /usr/sbin/sshd
root 3551 0.0 0.0 2620 748 ? Ss Dec26 0:00 xinetd -stayalive -pidfile /var/run/xinetd.
root 3564 0.0 0.0 5192 1220 ? S Dec26 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var
mysql 3594 13.1 1.9 721836 165796 ? Sl Dec26 134:39 /usr/sbin/mysqld --basedir=/ --datadir=/var
root 3625 0.0 0.0 3084 300 ? S Dec26 0:00 /usr/sbin/courierlogger -pid=/var/run/imapd
root 3626 0.0 0.0 2708 500 ? S Dec26 0:00 /usr/lib/courier-imap/libexec/couriertcpd -
root 3632 0.0 0.0 1600 224 ? S Dec26 0:00 /usr/sbin/courierlogger -pid=/var/run/imapd
root 3633 0.0 0.0 3504 472 ? S Dec26 0:00 /usr/lib/courier-imap/libexec/couriertcpd -
root 3638 0.0 0.0 2900 296 ? S Dec26 0:00 /usr/sbin/courierlogger -pid=/var/run/pop3d
root 3639 0.0 0.0 3608 500 ? S Dec26 0:00 /usr/lib/courier-imap/libexec/couriertcpd -
root 3644 0.0 0.0 2312 224 ? S Dec26 0:00 /usr/sbin/courierlogger -pid=/var/run/pop3d
root 3645 0.0 0.0 2900 472 ? S Dec26 0:00 /usr/lib/courier-imap/libexec/couriertcpd -
mailnull 3702 0.0 0.0 8704 900 ? Ss Dec26 0:00 /usr/sbin/exim -bd -q60m
mailnull 3707 0.0 0.0 9372 848 ? Ss Dec26 0:00 /usr/sbin/exim -tls-on-connect -bd -oX 465
root 3742 0.0 0.0 6668 1144 ? Ss Dec26 0:00 pure-ftpd (SERVER)
root 3745 0.0 0.0 6560 672 ? S Dec26 0:00 /usr/sbin/pure-authd -s /var/run/ftpd.sock
root 3753 0.0 0.0 5300 924 ? Ss Dec26 0:00 crond
root 4016 0.0 0.0 4920 1916 ? SN Dec26 0:00 cpanellogd - sleeping for logs
dbus 4065 0.0 0.0 3376 800 ? Ss Dec26 0:00 dbus-daemon-1 --system
root 4082 0.0 0.0 5432 2660 ? Ss Dec26 0:03 hald
root 4103 0.0 0.0 1500 400 ? Ss Dec26 0:00 /usr/sbin/portsentry -tcp
root 4120 0.0 0.0 2844 404 tty1 Ss+ Dec26 0:00 /sbin/mingetty tty1
root 4121 0.0 0.0 1696 404 tty2 Ss+ Dec26 0:00 /sbin/mingetty tty2
root 4122 0.0 0.0 2368 408 tty3 Ss+ Dec26 0:00 /sbin/mingetty tty3
root 4123 0.0 0.0 1812 404 tty4 Ss+ Dec26 0:00 /sbin/mingetty tty4
root 4124 0.0 0.0 1812 404 tty5 Ss+ Dec26 0:00 /sbin/mingetty tty5
root 4125 0.0 0.0 3264 408 tty6 Ss+ Dec26 0:00 /sbin/mingetty tty6
root 7851 0.0 0.1 40168 11848 ? Ss Dec26 0:10 /usr/local/apache/bin/httpd -k start -DSSL
root 7857 0.0 0.0 19100 6348 ? S Dec26 0:00 /usr/local/apache/bin/httpd -k start -DSSL
named 7981 0.0 0.0 68440 2876 ? Ssl Dec26 0:02 /usr/sbin/named -u named
root 21424 0.0 0.0 7428 2348 ? Ss 09:29 0:00 sshd: root@pts/0
root 21429 0.0 0.0 6268 1392 pts/0 Ss 09:29 0:00 -bash
root 21709 0.0 0.0 16948 7988 ? S Dec26 0:00 cpsrvd - waiting for connections
nobody 22873 0.1 0.2 45180 20288 ? S 10:01 0:01 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23199 4.1 0.2 47312 22232 ? S 10:07 0:13 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23200 1.1 0.2 43932 19312 ? S 10:07 0:03 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23249 0.0 0.2 46868 20932 ? S 10:08 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23250 0.1 0.2 44908 21472 ? S 10:08 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23256 0.2 0.2 44964 19892 ? S 10:08 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23257 0.4 0.2 44412 19292 ? S 10:08 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23263 0.1 0.2 46096 20900 ? S 10:08 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23266 0.1 0.2 45192 19920 ? S 10:09 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23292 0.4 0.2 45724 20512 ? S 10:09 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23295 0.7 0.2 44176 19976 ? S 10:09 0:01 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23296 0.2 0.2 44120 19120 ? S 10:09 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23299 0.3 0.2 45708 20288 ? S 10:09 0:00 /usr/local/apache/bin/httpd -k start -DSSL
root 23304 0.4 0.0 0 0 ? S 10:09 0:00 [pdflush]
nobody 23306 0.0 0.2 44780 18052 ? S 10:09 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23307 0.1 0.2 44120 18956 ? S 10:09 0:00 /usr/local/apache/bin/httpd -k start -DSSL
root 23315 0.3 0.0 0 0 ? D 10:09 0:00 [pdflush]
root 23320 0.0 0.0 5936 1244 ? S 10:10 0:00 crond
root 23321 0.0 0.0 2576 480 ? Ds 10:10 0:00 /usr/lib/sa/sadc -F -L 1 1 /var/log/sa/sa27
nobody 23341 0.0 0.2 45324 18868 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23360 0.5 0.2 49640 23624 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23361 0.1 0.2 45288 19044 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23364 0.0 0.2 45064 18420 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23366 0.0 0.2 45324 18720 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23368 0.4 0.2 47904 21516 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23370 0.1 0.2 47148 21220 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23374 0.0 0.2 44812 17804 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23375 1.6 0.2 45296 19080 ? S 10:10 0:01 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23379 0.0 0.2 45816 18776 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23381 0.0 0.2 44264 17496 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23382 0.0 0.2 46364 19544 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23384 0.0 0.2 44508 18092 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23385 0.1 0.2 45288 19028 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23386 0.1 0.2 46688 21320 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23387 0.0 0.2 44004 17432 ? S 10:10 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23417 0.2 0.2 43984 16724 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23420 0.0 0.2 44004 17424 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23421 0.0 0.2 44004 17424 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23422 0.0 0.2 44508 18088 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23423 0.1 0.2 44024 17856 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23424 0.0 0.2 44508 18096 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23425 0.0 0.2 44508 18092 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23430 0.0 0.2 44768 18676 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23432 0.0 0.2 44508 18100 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23434 0.2 0.2 46696 19628 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23435 0.1 0.2 46364 19548 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23439 0.0 0.1 43728 16548 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23441 0.0 0.2 44248 17116 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23442 0.0 0.1 41480 13808 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23445 0.0 0.1 41480 13844 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23446 0.0 0.2 44508 18064 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23447 0.0 0.1 43728 16548 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23448 0.0 0.2 44248 17168 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23453 0.0 0.1 41472 13796 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23455 0.0 0.1 41472 13796 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23456 0.0 0.1 41464 13724 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23458 0.0 0.1 41244 13680 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23461 0.0 0.1 41220 13680 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23466 0.0 0.1 42008 14600 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23467 0.0 0.1 41464 13728 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23470 0.0 0.1 41464 13720 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23474 0.0 0.1 41464 13728 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23476 0.0 0.1 42008 14596 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23478 0.0 0.1 42008 14596 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23482 0.0 0.1 41464 13728 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23486 0.0 0.1 41208 13616 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23487 0.0 0.1 41464 13728 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23488 0.0 0.1 40304 10904 ? S 10:11 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23492 0.0 0.1 40304 10904 ? S 10:12 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23516 0.0 0.1 40168 10216 ? S 10:12 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23517 0.0 0.1 41464 13724 ? S 10:12 0:00 /usr/local/apache/bin/httpd -k start -DSSL
nobody 23519 0.0 0.1 40168 10216 ? S 10:12 0:00 /usr/local/apache/bin/httpd -k start -DSSL
mailnull 23521 0.0 0.0 9032 1864 ? D 10:12 0:00 /usr/sbin/exim -bd -q60m
nobody 23523 0.0 0.1 40168 10216 ? S 10:12 0:00 /usr/local/apache/bin/httpd -k start -DSSL
root 23524 0.0 0.0 3468 760 pts/0 R+ 10:12 0:00 ps -aux
./tuning-primer.sh çıktısı -- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -
MySQL Version 5.0.67-community i686
Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations
To find out more information on how each of these
runtime variables effects performance visit:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
Visit http://www.mysql.com/products/enterprise/advisors.html
for info about MySQL's Enterprise Monitoring and Advisory Service
SLOW QUERIES
The slow query log is NOT enabled.
Current long_query_time = 10 sec.
You have 1002 out of 953127 that take longer than 10 sec. to complete
Your long_query_time may be too high, I typically set this under 5 sec.
BINARY UPDATE LOG
The binary update log is NOT enabled.
You will not be able to do point in time recovery
See http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html
WORKER THREADS
Current thread_cache_size = 8
Current threads_cached = 6
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 100
Current threads_connected = 3
Historic max_used_connections = 101
The number of used connections is 101% of the configured maximum.
You should raise max_connections
MEMORY USAGE
Max Memory Ever Allocated : 1 G
Configured Max Per-thread Buffers : 631 M
Configured Max Global Buffers : 538 M
Configured Max Memory Limit : 1 G
Physical Memory : 7.91 G
Max memory limit seem to be within acceptable norms
KEY BUFFER
Current MyISAM index space = 86 M
Current key_buffer_size = 512 M
Key cache miss rate is 1 : 829
Key buffer fill ratio = 9.00 %
Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere
QUERY CACHE
Query cache is enabled
Current query_cache_size = 16 M
Current query_cache_used = 8 M
Current query_cache_limit = 1 M
Current Query cache Memory fill ratio = 55.28 %
Current query_cache_min_res_unit = 4 K
Query Cache is 28 % fragmented
Run "FLUSH QUERY CACHE" periodically to defragment the query cache memory
If you have many small queries lower 'query_cache_min_res_unit' to reduce fragmentation.
MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS
Current sort_buffer_size = 1 M
Current read_rnd_buffer_size = 4 M
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 132.00 K
You have had 24 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.
OPEN FILES LIMIT
Current open_files_limit = 1024 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 256 tables
You have a total of 201 tables
You have 256 open tables.
Current table_cache hit rate is 1%, while 100% of your table cache is in use
You should probably increase your table_cache
TEMP TABLES
Current max_heap_table_size = 16 M
Current tmp_table_size = 32 M
Of 17848 temp tables, 2% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Created disk tmp tables ratio seems fine
TABLE SCANS
Current read_buffer_size = 1 M
Current table scan ratio = 1262 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 64
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
If you have a high concurrency of inserts on Dynamic row-length tables
consider setting 'concurrent_insert=2'. pico /etc/my.cnf # The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 512M
max_allowed_packet = 16M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
pico /usr/local/apache/conf/httpd.conf
Özellikle burada daha fazla değer olması gerekiyor diye düşünüyorum.
PidFile logs/httpd.pid
LockFile logs/accept.lock
# Defined in /var/cpanel/cpanel.config: apache_port
Listen 0.0.0.0:80
Timeout 300
User nobody
Group nobody
ExtendedStatus On