HTTPD : Speed from the 90s of the Web

Hi,

May I have your idea about httpd CPU consumption ?

We have 2-3 websites hosted on a linux.os server
Some could believe linux + mysql is not a bad configuration : but not
sure.
.. At some period during the day, the http website can not be accessed
at all. http page are very slow (like 10 to 30 seconds to appear).
Read the access log : each access log read, but no solution.
Ensure sql-connect : all sql querries are open and closed properly.

TOP : viewing the processes, when nothing matters correctly, we notice
that the httpd process consume 15 to 30% of the CPU. We are mas-o-menos
sure that the problem take its source from there.

You experience in that domain will help us so much.

Thanks : many thanks for your answer.

Henry

(E-Mail Removed) wrote:
> Hi,
>
> May I have your idea about httpd CPU consumption ?
>
> We have 2-3 websites hosted on a linux.os server
> Some could believe linux + mysql is not a bad configuration : but not
> sure.
> . At some period during the day, the http website can not be accessed
> at all. http page are very slow (like 10 to 30 seconds to appear).
> Read the access log : each access log read, but no solution.
> Ensure sql-connect : all sql querries are open and closed properly.
>
> TOP : viewing the processes, when nothing matters correctly, we notice
> that the httpd process consume 15 to 30% of the CPU. We are mas-o-menos
> sure that the problem take its source from there.
>
> You experience in that domain will help us so much.
>
> Thanks : many thanks for your answer.
>
> Henry
>
You are telling us very little about how your web server is set up. For
example.

1. What httpd are you using (e.g. apache2)
2. How are your web pages accessing your database? (e.g. php4, perl, python)
3. How much traffic is passing through?
4. What is your hardware? Does it swap much?

If you let the newsgroup know, then someone may be able to help.

Robert

On Mon, 16 Oct 2006 09:09:03 -0700, Henry16 wrote:

> http page are very slow (like 10 to 30 seconds to appear).

Where are you accessing them from? Could this be a DNS problem?

Dan

Dan N wrote:
> On Mon, 16 Oct 2006 09:09:03 -0700, Henry16 wrote:
>
> > http page are very slow (like 10 to 30 seconds to appear).
>
> Where are you accessing them from? Could this be a DNS problem?
>
> Dan

****************************
Many thanks Sirs Harris & Dan for your help... and maybe you will
accept my excuses concerning my delay in response.

Situation is getting from bad to the worst :

The server is a Fedora Linux / Apache 2.0 with MySQL. Scripts written
in PHP.


We receive a very little traffic : more or less 2.500 people per day
visiting 1 or 2 pages.


We reviewed all LOGS + SQL scripts + Weight of pages. Our website may
be will always stay nothing due to lack of speed and we do not have
much
knowhow in web servers applied sciences.


SERVER (View Process) *******************


3122 root 16 0 1248 1248 376 S 0.0 0.1 0:00 0 klogd
3146 root 16 0 660 660 476 S 0.0 0.0 0:00 0 smartd

15:42:43 up 2 days, 1:24, 2 users, load average: 1.73, 1.29, 1.10
215 processes: 214 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait
idle
total 17.9% 0.0% 6.2% 0.0% 0.0% 0.0%
75.7%
Mem: 1016508k av, 977304k used, 39204k free, 0k shrd,
108584k buff
374780k active, 536556k inactive
Swap: 2097136k av, 64892k used, 2032244k free
343616k cached


PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU
COMMAND
27852 root 16 0 10676 10M 10580 S 19.8 1.0 3:43 0 httpd

10543 root 17 0 1292 1292 900 R 1.5 0.1 0:01 0 top
11783 mysql 15 0 7260 7260 2644 S 0.9 0.7 0:23 0
mysqld
27873 root 15 0 824 824 532 S 0.1 0.0 0:01 0
exclog
1 root 16 0 428 428 372 S 0.0 0.0 0:06 0 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0
keventd
3 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0
ksoftirqd/0
5 root 25 0 0 0 0 SW 0.0 0.0 0:00 0
bdflush
4 root 15 0 0 0 0 SW 0.0 0.0 0:05 0
kswapd
6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0
kupdated
7 root 24 0 0 0 0 SW 0.0 0.0 0:00 0
mdrecoveryd
11 root 15 0 0 0 0 SW 0.0 0.0 0:05 0
kjournald
67 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 khubd

555 root 15 0 0 0 0 SW 0.0 0.0 0:00 0
kjournald
3102 root 16 0 576 576 496 S 0.0 0.0 0:00 0
syslogd
3122 root 16 0 1248 1248 376 S 0.0 0.1 0:00 0 klogd

3146 root 16 0 660 660 476 S 0.0 0.0 0:00 0
smartd
3168 root 16 0 1676 1672 1524 S 0.0 0.1 0:00 0 sshd
3178 root 21 0 1492 1492 1296 S 0.0 0.1 0:00 0 sshd
3193 root 16 0 876 876 744 S 0.0 0.0 0:00 0
xinetd
3218 root 16 0 2924 2920 2648 S 0.0 0.2 0:00 0
sendmail
3227 smmsp 16 0 2560 2548 1936 S 0.0 0.2 0:00 0
sendmail
3336 postgres 16 0 1896 1896 1808 S 0.0 0.1 0:00 0
postmaster
3338 postgres 16 0 1944 1944 1808 S 0.0 0.1 0:00 0
postmaster
3339 postgres 15 0 1904 1904 1800 S 0.0 0.1 0:00 0
postmaster
3354 root 16 0 2220 2216 1628 S 0.0 0.2 0:00 0
proftpd
3398 root 6 -10 3372 3372 3204 S < 0.0 0.3 0:00 0
ocwhttpd
3399 nobody 6 -10 3268 3268 3040 S < 0.0 0.3 0:00 0
ocwhttpd
3409 root 6 -10 41196 24M 8368 S < 0.0 2.4 0:10 0
ensim-python
3418 root 16 0 1280 1276 1076 S 0.0 0.1 0:02 0
bandwidth_manag
3427 root 16 0 640 640 544 S 0.0 0.0 0:00 0 crond

3444 daemon 16 0 592 564 512 S 0.0 0.0 0:00 0 atd
3453 root 16 0 564 516 480 S 0.0 0.0 0:00 0
saslauthd
3741 root 18 0 356 356 304 S 0.0 0.0 0:00 0
mingetty
3742 root 18 0 352 352 304 S 0.0 0.0 0:00 0
mingetty
3743 root 19 0 356 356 304 S 0.0 0.0 0:00 0
mingetty
3744 root 19 0 356 356 304 S 0.0 0.0 0:00 0
mingetty
3745 root 20 0 356 356 304 S 0.0 0.0 0:00 0
mingetty
3747 root 21 0 356 356 304 S 0.0 0.0 0:00 0
mingetty
28624 root 16 0 16252 2192 1992 S 0.0 0.2 0:08 0
MailScanner
11752 root 18 0 972 972 840 S 0.0 0.0 0:00 0
safe_mysqld
26679 root 16 0 3404 3396 2996 S 0.0 0.3 0:00 0
sendmail
9344 root 16 0 2336 2328 2004 S 0.0 0.2 0:00 0 sshd
9441 root 15 0 1392 1392 1144 S 0.0 0.1 0:00 0 bash
9521 root 17 0 1288 1288 896 S 0.0 0.1 0:02 0 top
10310 root 16 0 2320 2312 2004 S 0.0 0.2 0:00 0 sshd
10473 root 16 0 1392 1392 1144 S 0.0 0.1 0:00 0 bash


TRACERT *******************


Détermination de l'itinéraire vers www.adverland.com [207.36.196.211]

avec un maximum de 30 sauts :


1 1 ms 1 ms 1 ms WANADOO-6120 [192.168.1.1]
2 * * * Délai d'attente de la demande
dépassé.
3 42 ms 41 ms 42 ms 10.224.0.5
4 42 ms 41 ms 41 ms
pos1-0.nraub203.Aubervilliers.francetelecom.net[193.252.98.154]
5 * * * Délai d'attente de la demande
dépassé.
6 50 ms 51 ms 49 ms cogent.GW.opentransit.net
[193.251.254.242]
7 57 ms 54 ms 53 ms p12-0.core01.par01.atlas.cogentco.com
[130.117.1.238]
8 134 ms 130 ms 132 ms p14-0.core02.dca01.atlas.cogentco.com
[66.28.4.206]
9 143 ms 142 ms 143 ms p14-0.core01.atl01.atlas.cogentco.com
[66.28.4.161]
10 149 ms 148 ms 149 ms p14-0.core01.jax01.atlas.cogentco.com
[154.54.3.198]
11 159 ms 157 ms 157 ms p15-0.core01.mia01.atlas.cogentco.com
[66.28.4.137]
12 157 ms 157 ms 157 ms
v3525.na21.b015447-0.mia01.atlas.cogentco.com [38.112.35.178]
13 157 ms 156 ms 156 ms telefonicausa.demarc.cogentco.com
[66.28.21.126]
14 157 ms 157 ms 156 ms 66.231.240.2
15 158 ms 157 ms 156 ms 207.234.128.45
16 553 ms 471 ms * 207-36-196-211.ptr.primarydns.com
[207.36.196.211]
17 522 ms * 516 ms 207-36-196-211.ptr.primarydns.com
[207.36.196.211]


******************************


WS : http://tinyurl.com/vjble


******************************


Again, please receive my excuses about my dilay in responses. Thanks
for your potential to-be-followed comment.

Henry