I have an Amazon EC2 server with MySQL running, supporting databases for
- Three copies of WordPress
- One copy of Sendy
- Various odds and ends I have been experimenting with.
After some time, ranging between hours to days, MySQL seems to just shut down - causing WordPress to give the
Error establishing database connection
Much of my research into this seems to indicate that there are too many open connections - which would mean that something somewhere is not closing the SQL connection.
Note that how quickly MySQL does this seems to be in direct proportion to how much activity there is on the WP blogs.
Is there a way to find the root of these errors and sauté it?