I don't mean to interrupt, but we've had similar symptoms on my board for the past few months. Everything had been fine, but now the system hangs every few days (lots of Apache threads waiting). Eventually, it just fixes itself. I don't have the SQL details as bakerzdosen does. I have checked the settings described above and they're set correctly. We have a dedicated server. I don't know SQL commands well enough to try to diagnose when a problem is occurring, though.
I have a large number of posts (over 800,000). Is there some reorg command I could issue?
