Database Crash, Memory Overload

[ScottHughes]

I've been having an issue with my databases going down every once or twice every week or two, so forum, blogs and any other script that uses MYSQL do not work as a result. Unfortunately, it seems to be a problem that does not resolve itself. I have to have the server restarted. (So if I wake up in the morning and notice my databases aren't working, it could mean my sites have been unusable theoretically for 10 hours straight without my knowledge.)

This is a big problem for me of course.

I am going to work under the assumption that the problem is memory usage (not disk space). Although, I use two big scripts (phpBB2 and Wordpress), I have many little scripts (like 'contact us' forms, email subscriber lists, etc.) that are more likely poorly programmed and have memory leaks, open too many SQL connections, etc.

How would I identify which scripts/pages are the memory-hogs?

Also, is there a way to set it up so that I receive an email when the databases aren't working or when memory usage is starting to get too high?

Also, does anyone know of any modifications for phpBB2 or Wordpress (besides Wordpress Super Cache which I already have) that would lower memory usage?

Thanks,
Scott

[KODY]

To integrate WordPress with phpbb, many users use the following package:
http://www.wp-united.com/releases/wp-united-latest
Also, you can make additional configurations (include gzip compression) in page_header.php file to increase the performance of the forum.

[carlobee]

thanks for that one KODY!

[ScottHughes]

Thanks for your replies.

I'm not interested in intergrating Wordpres with phpBB. I use one on one site and one on another site.

I want to know how I can figure out which scripts/pages on my website are using the most memory.

Thanks,
Scott