httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Trawick <traw...@gmail.com>
Subject Re: [users@httpd] Apache crashing - lockf status
Date Wed, 13 Jul 2011 00:28:40 GMT
On Fri, Jul 8, 2011 at 5:34 PM, Rafael Hasson <rafaelhasson@gmail.com> wrote:
> Hello all!
>
> I've a webserver running PHP 5.2.17, Apache 2.2.17 and MySQL 5.5.13.
> Tables' storage engine are MyISAM. I'm having a problem with all httpd
> processes locking during peak hours.
> Today while investigating the problem, I could replicate the it (all httpd
> processes locking) while running a 2.2 seconds select statement.
> Does someone have a clue why a table locked for 2.2seconds is making all
> httpd processes goes to lockf state?
> On my understanding only MySQL should be on hold until statement completes,
> not httpd.
>
> After httpd goes to lockf, it never returns, I have to kill it and start
> again.
> This is how top lock then http://pastebin.com/uG7ZjD7A

Get backtraces of httpd processes to see where httpd is blocked.

prefork with multiple listening sockets?  Maybe the subset of httpd
processes in lockf state are just waiting for an incoming connection?
Backtraces will show.

---------------------------------------------------------------------
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