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 8/17/05 7:00 a.m. MST >>>Charlie Smith 8/16/2005 3:06:15 PM >>> 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 ------------------------------------------------------------------------------ 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
|