littlebigman

More info: # cat /proc/stat cpu 4648775 31 1100114 4544900 967595 14518 47729 0 cpu0 2413956 25 576313 2111222 501308 14518 44492 0 cpu1 2234818 5 523800 2433678 466287 0 3236 0 intr 29410811 252 2 0 0 0 0 3 0 0 0 0 0 0 0 2496073 0 26914481 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ctxt 90025117 btime 1199679073 processes 1107769 procs_running 1 procs_blocked 70 Is 14518 a lot for I/Owait? What about 70 for procs_blocked?

Yup, it's kinda weird. I'll tell him to ask the support guy about this. And I'll tell him to install the sysstat package, and run sar, mpstat, and iostat, since it looks like it's the hard-disk (possibly due to MySQL) that keeps so many processes in Sleep mode. This is interesting Thanks for your help guys.

I'll see what we can do. Forgot to say this site is running on a virtual shared server, which might explain the 476 running processes (not sure if this is the absolut number of processes running on the host, or just those running within this virtual host). No, single CPU. It's not possible. We only have one virtual server, but I'll see if we can kill and disable webalizer for a while, and see if perfs improve. OK. My friend tells me that he optimized the MySQL part, and that perfs are OK in that area, but I'll double-check to make sure he has proof of this. I heard of running "explain" and "show slow logs" to check this. He's already done this with Microcode(), so I guess that's how he told me that MySQL isn't a problem. How can I check if the problem is not I/O-bound, either the hard-disk or the network? Thanks.

Hello A friend of mine is running a LAMP application that's on its knees, and would like to know what to do about it: Either make changes to the PHP or MySQL code, or order a faster server. Here's what top says: top - 21:20:49 up 3:35, 1 user, load average: 61.88, 51.08, 74.30 Tasks: 476 total, 7 running, 467 sleeping, 0 stopped, 2 zombie Cpu(s): 78.8% us, 18.7% sy, 0.0% ni, 0.7% id, 0.3% wa, 0.5% hi, 1.0% si Mem: 1015484k total, 993344k used, 22140k free, 76920k buffers Swap: 514040k total, 101032k used, 413008k free, 208496k cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 10685 ze-card 19 19 984 736 724 R N 93.3 0.0 5671m webalizer 32072 nobody 9 0 16932 15M 12156 S 6.0 0.3 0:01 httpd 32196 nobody 9 0 16224 14M 12144 S 3.5 0.3 0:01 httpd 1868 nobody 9 0 16284 14M 12620 S 3.1 0.3 0:00 httpd 2136 nobody 9 0 16080 14M 12164 S 2.5 0.3 0:00 httpd 32205 nobody 9 0 16300 14M 12136 S 2.3 0.3 0:00 httpd 32231 nobody 9 0 16316 14M 12172 S 2.3 0.3 0:00 httpd 32124 nobody 9 0 16620 14M 12184 S 1.9 0.3 0:01 httpd Here's what vmstat says: procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 9 0 0 55588 87548 329824 0 0 166 292 369 896 69 17 5 9 8 0 0 49116 87572 330204 0 0 102 192 681 1686 71 25 4 0 5 0 0 45632 87584 330240 0 0 16 1298 765 1910 77 21 1 0 28 0 0 43072 87592 330296 0 0 8 86 737 2098 80 19 1 0 49 0 0 40676 87600 330384 0 0 32 1302 808 2139 76 22 3 1 52 0 0 40320 87628 330504 0 0 56 1078 855 2163 80 19 1 0 51 3 0 39904 87636 330560 0 0 32 244 822 1795 80 21 0 0 12 1 0 37816 87668 331280 0 0 342 1424 1121 2606 75 22 0 2 36 0 0 36708 87704 331648 0 0 150 186 798 2353 72 22 3 2 36 0 0 35660 87712 331784 0 0 38 24 896 1789 80 19 0 0 Can you tell what's wrong? Thank you for any tip.