buksida - 8:47 am on Aug 22, 2006 (gmt 0)

I have recently installed phpBB on a dedicated server with a bunch of other sites.

The forum has around 4-500 members and about 20,000 posts, its been running for about six weeks and is quite active now.

It seems that this forum is responsible for overloading mySQL and shutting the server down quite frequently.

Does anyone have any experience of how to troubleshoot something like this so I can get it running again without losing the server every few days? I have tried scripts to clear the sessions table but it appears this wasnt the cause of the shutdowns.