httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Charlie Smith" <Smit...@ldschurch.org>
Subject RE: [users@httpd] Strange qustion - how to prevent apache delay?
Date Tue, 23 Aug 2005 15:05:15 GMT
I moved the output into tables rather than leaving some of it out of tables.  
This in combination with upping the 
Apache Timeout seems to have solved problem.   Will run with new Timeout
parameter on production servers for awhile and
see if any problems.  I noticed that the Proxy (receive invalid response from
upstream servers) went away after I upped the Timeout
on the Proxy server.

Charlie
8/23/05 9:04 a.m. MST

>>> Charlie 8/18/2005 6:54:13 AM >>>
Did you debug the code? 
RE: Yes.  Problem only occurs with large data set.

Throw in some timers? 
RE: What would we be timing.   

Run some stats on your
queries?
RE: Explain plan on queries look good.

 I do not think that any of the process timeouts will do anything
for you, but I think you already found that out. 

What have you done on the oracle side to test this? 
RE: Queries run fine from sqlplus.  Explain plans analyzed.

Is the root of the problem:

  It takes too long to get html?
RE: Yes.  When data set is large, only the first html data up to the end of
the
first
<form> tag is returned.  (debug statements are also returned).   Then the next
echo "<br>..."
statement does not return - again only on large data set. On smaller data set,
all the stuff comes back.


  -OR-

  It does not return any html?
RE: No, only part of page is returned on large data set.  On smaller data set,
all is returned.


In either case, logic points to either database query bottlenecks, OR
looping queries. In which case, have you monitored your apache server as
the page is being requested? 
RE: Yes, entry in access log sometimes takes a long time to come up, when
query
is stopped on browser client and resubmitted.

Is RAM/Proc normal during the request? 
RE: Top shows ok.

There
is a remote possibility that something is out of whack in the php code. It
is highly doubtful that apache is involved. 
RE: I wouldn't count that out.  Question is what could it be?  Apache Timeout
used to be a factor in large data sets.
Doesn't appear to be now, though am not sure - it's set to 6000 now.

Charlie
8/18/05 6:53 a.m. MST



-----Original Message-----
From: Charlie Smith
Sent: Wednesday, August 17, 2005 9:07 AM
To:Tim Burden and apache users.
Subject: Re: [users@httpd] Strange qustion - how to prevent apache delay?

I removed the OT from the subject line, as I'm not convinced.

What else would keep Apache from putting entry in log file for accessing
the
php script?  Rather from taking so long to put the call in the access log?

Turning up the Apache Timeout var did not work.
Script is not eventually returning normally.  It is as if it stops half
way
through and client never gets html back from cgi script that is supposed
to.
So, maybe turning up max_execution_time would work?

Charlie


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org 
   "   from the digest: users-digest-unsubscribe@httpd.apache.org 
For additional commands, e-mail: users-help@httpd.apache.org 



------------------------------------------------------------------------------
This message may contain confidential information, and is
intended only for the use of the individual(s) to whom it
is addressed.
------------------------------------------------------------------------------


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org 
   "   from the digest: users-digest-unsubscribe@httpd.apache.org 
For additional commands, e-mail: users-help@httpd.apache.org 



------------------------------------------------------------------------------
This message may contain confidential information, and is
intended only for the use of the individual(s) to whom it
is addressed.
------------------------------------------------------------------------------


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message