[support] Severe Hanging (and sometimes MySql crashes) When Approving Comments

[Big Brother]

Thanks for the responses.

I have too many modules to list them all... it would take too long.

It's something to do with MySql accessing the comments table. It then
locks and hangs.

I am not using persistent connections.

The Processlist indicates a number of 'SELECT count(node.nid) FROM
node LEFT JOIN
comments' statements which send data forever, and a few 'SELECT node.nid,
comments.timestamp' which copy to tmp forever.

Possible relevant modules:
Karma
Path
Localizer
Panels

-David

On Mon, Jun 16, 2008 at 2:09 AM, Davide Michel 'ZioBudda' Morelli
<michel at ziobudda.net> wrote:
> Big Brother ha scritto:
>> Hello everyone,
>>
>> I'm experience a hard-to-find bug. I don't know exactly where it is,
>> but only a few triggers of the problem.
>>
>> When I approve comments (from the approval queue), whether it be one
>> or ten, it hangs for several minutes and sometimes results in a
>> complete MySql crash, where I have no other option other than to reset
>> the MySql server.
>>
>>
>
> Which modules do you have installed ?
>
> Have you the possibility to use phpMyAdmin (web) or mytop (shell) to see
> which queries are running ?
>
> M.
>
> --
> Michel 'ZioBudda' Morelli                       michel at ziobudda.net
> Consulenza sistemistica in ambito OpenSource.
> Sviluppo applicazioni web dinamiche (LAMP+Ajax)
> Telefono: 0200619074
> Telefono Cell: +39-3939890025 --  Fax: +39-0291390660
>
> http://www.ziobudda.net                         ICQ: 58351764
> http://www.ziobuddalabs.it                      Skype: zio_budda
> http://www.ziodrupal.net                        MSN: michel at ziobuddalabs.it
>                                                JABBER: michel at gmail.com
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>