httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Burden" <...@burden.ca>
Subject Re: [users@httpd] [OT] Strange qustion - how to prevent apache delay?
Date Tue, 16 Aug 2005 20:09:04 GMT
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" <SmithCW@ldschurch.org>
To: <users@httpd.apache.org>; <joshua.kugler@uaf.edu>
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@httpd.apache.org
>    "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>
>
> --------------------------------------------------------------------------
----
> 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@httpd.apache.org
>    "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>
>
> --------------------------------------------------------------------------
----
> 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@httpd.apache.org
>    "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>


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


Mime
View raw message