RE: [users@httpd] Strange qustion - how to prevent apache delay?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx 
   "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx 
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx 



------------------------------------------------------------------------------
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@xxxxxxxxxxxxxxxx
   "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx



[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux