MySQL висит на sending data:<div><br></div><div><div>mysql> show processlist;</div><div>+-----+-------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+</div>
<div>| Id | User | Host | db | Command | Time | State | Info |</div><div>+-----+-------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+</div>
<div>| 2 | root | localhost | nowaru_BakS | Query | 0 | NULL | show processlist |</div><div>| 3 | nowaru_baks | localhost | nowaru_BakS | Query | 17 | <span class="Apple-style-span" style="font-weight: bold;">Sending data</span> | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and i.iblog=1 and i.inumber<>2 and i |</div>
<div>| 4 | nowaru_baks | localhost | nowaru_BakS | Query | 31 | <span class="Apple-style-span" style="font-weight: bold;">Sending data </span>| SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and i.iblog=1 and i.inumber<>2 and i |</div>
<div>| 5 | nowaru_baks | localhost | nowaru_BakS | Query | 14 | <span class="Apple-style-span" style="font-weight: bold;">Sending data</span> | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and i.iblog=1 and i.inumber<>2 and i |</div>
<div>| 6 | nowaru_baks | localhost | nowaru_BakS | Query | 34 | <span class="Apple-style-span" style="font-weight: bold;">Sending data</span> | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and i.iblog=1 and i.inumber<>2 and i |</div>
<div>| 7 | nowaru_baks | localhost | nowaru_BakS | Query | 87 | <span class="Apple-style-span" style="font-weight: bold;">Sending data</span> | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and i.iblog=1 and i.inumber<>2 and i |</div>
<div><br></div><br><div class="gmail_quote">On Thu, Dec 18, 2008 at 4:54 PM, Alex Vorona <span dir="ltr"><<a href="mailto:voron@amhost.net">voron@amhost.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
18.12.2008 16:31, Дмитрий Леоненко wrote:<br>
[...]<div class="Ih2E3d"><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
(gdb) where<br>
#0 0x282dd447 in read () from /lib/libc.so.5<br>
#1 0x28272b5d in read () from /usr/lib/libpthread.so.1<br>
#2 0x289eaf41 in vio_read () from /usr/local/lib/mysql/libmysqlclient.so.16<br>
#3 0x289eafae in vio_read_buff () from /usr/local/lib/mysql/libmysqlclient.so.16<br>
#4 0x289ebcf0 in my_real_read () from /usr/local/lib/mysql/libmysqlclient.so.16<br>
#5 0x289ebeed in my_net_read () from /usr/local/lib/mysql/libmysqlclient.so.16<br>
#6 0x289e5bfa in cli_safe_read () from /usr/local/lib/mysql/libmysqlclient.so.16<br>
</blockquote></div>
[...]<br>
похоже, тормозит mysql при вызове из php, включайте ExtendedStatus у апача и смотрите туда<br>
<br>
</blockquote></div><br></div>