
27-12-2008, 10:27:56
|
| |
Server Optimasyon - Yardım İsteği | | 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ı PHP- Kodu: 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ı
[ PHP- Kodu: 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ı PHP- Kodu: -- 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 PHP- Kodu: # 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. PHP- Kodu: 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
|