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

["Дмитрий Леоненко" <dmitry.leonenko@xxxxxxxxx>]

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@xxxxxxxxxx> 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 у апача и смотрите туда