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

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.

Also, when I delete comments as well I get this long hang and occasional crashes. It's obviously something with how Drupal is interacting with the MySql DB when calling comments.

When the crashes occur the error is a basic "Too many connections..." MySql error.

Anyone ever experienced this before? Let me know if anyone needs some clarification of my explanation.

Cheers,

David