My theory is that the "use persistent connection" setting in smf leaves the mySQL connections open for way too long (I've seen 100+ connections piled up doing nothing on previous occasions), so I've turned that off. Let me know if it happens again and I'll boost the max connections setting on mySQL.