PHP DB - Re: [PHP-DB] slow loading page

Author

Re: [PHP-DB] slow loading page

Micah Stevens

2006-02-13, 6:56 pm

Not enough information there to make any sort of diagnosis, but here are some
things to try to narrow down the problem:

1) ssh into the server, and run 'top' to watch the process list. Then while
watching that, hit reload in the browser to see if the HTTP process pegs out
while you're waiting for the page. If it does, for some reason apache/php is
struggling. Otherwise it's likely something else.

2) run 'ngrep' on port 80 of the incoming network interface (eth0, or whatever
it's hooked to), and reload the page again. Are you immediatly seeing the
request come though or does it take a while? This type of thing could be
caused not by the webserver, but instead by a badly configured router, or
something in the network. If it takes a while to come through, you need to
look at your network configuration.

3) Is this a DNS issue? If you're accessing via a domain name, and not a
direct IP type URL, a shoddy DNS connection could make things really take a
long time.

4) If it is an apache issue, turn on extended status, and watch that while you
reload the page, that can give you an idea of what's taking so long.

I'm sure others will have even better troubleshooting ideas, but that's a
start I guess.

-Micah

On Monday 13 February 2006 2:11 pm, redhat wrote:
> I have just installed Centos 4.2 running on a new Dell server (Xeon
> 2.4Ghz, SCSI HD, 1GB RAM) with apache 2.0.52, PHP 4.3.9 and MySQL
> 4.1.12. There is NOTHING in the html directory yet except for a simple
> index.php page with two echo statements in it for demo purposes. The
> statement is as follows:
> <?php
> echo ("<h2>Hello World</h2>");
> echo ("font color=\"red\" face=\"helvetica\" size=\"20px\">This is
> www.domain.com</font>");
> ?>
>
> This page takes about 20 seconds to load. When I do the same page but
> with plain html it loads in a fraction of a second. The server is about
> 20 feet away from me in a server room too. I didn't compile the PHP or
> apache from source either - it is from the disro install. Anyone else
> have any issues like this? I should have virtually zero latency on this
> set up. I also turned on (php.ini) error display and I get no errors
> displayed nor any in the log files - it just takes forever to load.
> When I do a <?php phpcredits(); ?> it also takes about the same amount
> of time to load.
> thanks,
> Doug

David Robley

2006-02-14, 3:55 am

Micah Stevens wrote:

>
> Not enough information there to make any sort of diagnosis, but here are
> some things to try to narrow down the problem:
>
> 1) ssh into the server, and run 'top' to watch the process list. Then
> while watching that, hit reload in the browser to see if the HTTP process
> pegs out while you're waiting for the page. If it does, for some reason
> apache/php is struggling. Otherwise it's likely something else.
>
> 2) run 'ngrep' on port 80 of the incoming network interface (eth0, or
> whatever it's hooked to), and reload the page again. Are you immediatly
> seeing the request come though or does it take a while? This type of thing
> could be caused not by the webserver, but instead by a badly configured
> router, or something in the network. If it takes a while to come through,
> you need to look at your network configuration.
>
> 3) Is this a DNS issue? If you're accessing via a domain name, and not a
> direct IP type URL, a shoddy DNS connection could make things really take
> a long time.

3a) If so, is hostname lookup turned on for apache logging? This may result
in yet another query to the DNS. I'm not sure however whether that lookup
might delay delivery of the document, or whether the document is served
independently og logging actions; I would guess the latter.

Cheers
--
David Robley

"I'm never anywhere on time," Tom related.

Sponsored Links