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
|