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: [users@httpd] [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: [users@httpd] 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: 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 > > > > > > > > -------------------------------------------------------------------------- > ---- > > 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 > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
|