Re: Накопление процессов апача

[Дмитрий Леоненко]

MySQL висит на sending data:
mysql> show processlist;
+-----+-------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id  | User        | Host      | db          | Command | Time | State
 | Info
                            |
+-----+-------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
|   2 | root        | localhost | nowaru_BakS | Query   |    0 | NULL
  | show processlist
                            |
|   3 | nowaru_baks | localhost | nowaru_BakS | Query   |   17 | Sending
data | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and
i.iblog=1 and i.inumber<>2 and i |
|   4 | nowaru_baks | localhost | nowaru_BakS | Query   |   31 | Sending
data | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and
i.iblog=1 and i.inumber<>2 and i |
|   5 | nowaru_baks | localhost | nowaru_BakS | Query   |   14 | Sending
data | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and
i.iblog=1 and i.inumber<>2 and i |
|   6 | nowaru_baks | localhost | nowaru_BakS | Query   |   34 | Sending
data | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and
i.iblog=1 and i.inumber<>2 and i |
|   7 | nowaru_baks | localhost | nowaru_BakS | Query   |   87 | Sending
data | SELECT COUNT(i.inumber) FROM nucleus_item as i WHERE i.idraft=0 and
i.iblog=1 and i.inumber<>2 and i |


On Thu, Dec 18, 2008 at 4:54 PM, Alex Vorona <voron at amhost.net> wrote:

> 18.12.2008 16:31, Дмитрий Леоненко wrote:
> [...]
>
>> (gdb) where
>> #0  0x282dd447 in read () from /lib/libc.so.5
>> #1  0x28272b5d in read () from /usr/lib/libpthread.so.1
>> #2  0x289eaf41 in vio_read () from
>> /usr/local/lib/mysql/libmysqlclient.so.16
>> #3  0x289eafae in vio_read_buff () from
>> /usr/local/lib/mysql/libmysqlclient.so.16
>> #4  0x289ebcf0 in my_real_read () from
>> /usr/local/lib/mysql/libmysqlclient.so.16
>> #5  0x289ebeed in my_net_read () from
>> /usr/local/lib/mysql/libmysqlclient.so.16
>> #6  0x289e5bfa in cli_safe_read () from
>> /usr/local/lib/mysql/libmysqlclient.so.16
>>
> [...]
> похоже, тормозит mysql при вызове из php, включайте ExtendedStatus у апача
> и смотрите туда
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nginx.org/pipermail/nginx-ru/attachments/20081218/c3f9ed4f/attachment.html>