MetaChat is an informal place for MeFites to touch base and post, discuss and
chatter about topics that may not belong on MetaFilter. Questions? Check the FAQ. Please note: This is important.
Unfortunately, the answer is currently - I don't know.
I believe that there's some unoptimised queries which are causing MySQL to max out the server. I don't know what these queries do, but turning off the (x new comments) functionality appears to either stop them being called or stops them taking so long.
I investigate. Slowly. Like a man who knows not what he searches for.