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@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@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@ziobuddalabs.it JABBER: michel@gmail.com
-- [ Drupal support list | http://lists.drupal.org/ ]