Perhaps upping the Apache Timeout variable.   I've tried that and will let you
know.

>>> Tim Burden 8/16/2005 2:23:16 PM >>>
They are default and are therefore fine. You wouldn't turn up
max_execution_time if the scripts are eventually returning normally.

Don't know anything about Oracle. This is now completely OT, nothing to do
with Apache.

----- Original Message ----- 
From: "Charlie Smith"
Sent: Tuesday, August 16, 2005 4:20 PM
Subject: Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache
delay?


> Perhaps turning up max_execution_time  As script sometimes does take over
5
> minutes to actually
> return data?  We can expect some of the queries to actually take longer
that 10
> seconds.  Also,
> am using Oracle as db rather than MySQL.
>
> max_execution_time = 30     ; Maximum execution time of each script, in
> seconds
> max_input_time = 60     ; Maximum amount of time each script may spend
parsing
> request data
> memory_limit = 8M      ; Maximum amount of memory a script may consume
(8MB)
>
> How do the above limits look?
>
> Charlie
> 8/16/05 2:20 p.m. MST
>
> >>> Tim Burden 8/16/2005 2:09:04 PM >>>
> This is off-topic, but in my experience this is almost always a problem
with
> queries that are taking too long to process. You can turn on the MySQL
slow
> query log to try to determine this, but often the quick answer is to
> double-check that you have proper indexes on any field used in a WHERE
> clause. Learning to use EXPLAIN can help you determine where you need
> indexes.
>
> Another trick is to turn max_execution_time down below 10 seconds in
> php.ini. If the script can still execute, and still takes more than ten
> seconds, then you know its a query problem, since the time spent waiting
for
> a query to return is not counted.
>
> ----- Original Message ----- 
> From: "Charlie Smith"
> Sent: Tuesday, August 16, 2005 3:29 PM
> Subject: Re: [EMAIL PROTECTED] Strange qustion - how to prevent apache delay?
>
>
> > Problem with very long response time for php cgi scripts started
occurring
> after
> > some of the
> > program seemed to drop off to never land, as queries and arrays got a
lot
> > bigger.
> > I turned on implicit_flush to try and debug, but problem persists.
Takes
> over
> > 10 minutes just
> > to get a line back from the php script.
> >
> > Charlie
> > 8/16/05 1:29 p.m. MST
> >
> > >>> Joshua Kugler 8/16/2005 12:37:59 PM >>>
> > Are you using the debug php.ini or the production php.ini?  We had this
> > problem too and it turned out that we were using the default .ini file
> that
> > has a big header at the top that says "Do not use this in production."
> >
> > j----- k-----
> >
> > On Tuesday 16 August 2005 10:32, Charlie Smith wrote:
> > > I noticed recent post on how to create a delay in a post.  I have
> opposite
> > > problem.
> > > In running some php scripts, it's taking up to 10 and longer just to
get
> a
> > > line in the
> > > access log.
> > >
> > > Any ideas?
> > >
> > > Charlie
> > > 8/16/05 12:32 p.m. MST
> >
> > -- 
> > Joshua Kugler
> > CDE System Administrator
> > http://distance.uaf.edu/ 
> >
> > ---------------------------------------------------------------------
> > 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: [EMAIL PROTECTED] 
> >    "   from the digest: [EMAIL PROTECTED] 
> > For additional commands, e-mail: [EMAIL PROTECTED] 
> >
> >
> >
>
> --------------------------------------------------------------------------
> ----
> > 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: [EMAIL PROTECTED] 
> >    "   from the digest: [EMAIL PROTECTED] 
> > For additional commands, e-mail: [EMAIL PROTECTED] 
> >
> >
> >
>
> --------------------------------------------------------------------------
> ----
> > 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: [EMAIL PROTECTED] 
> >    "   from the digest: [EMAIL PROTECTED] 
> > For additional commands, e-mail: [EMAIL PROTECTED] 
> >
>
>
> ---------------------------------------------------------------------
> 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: [EMAIL PROTECTED] 
>    "   from the digest: [EMAIL PROTECTED] 
> For additional commands, e-mail: [EMAIL PROTECTED] 
>
>
>
> --------------------------------------------------------------------------
----
> 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: [EMAIL PROTECTED] 
>    "   from the digest: [EMAIL PROTECTED] 
> For additional commands, e-mail: [EMAIL PROTECTED] 
>


---------------------------------------------------------------------
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: [EMAIL PROTECTED] 
   "   from the digest: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 



------------------------------------------------------------------------------
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: [EMAIL PROTECTED]
   "   from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to