Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

Message.

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?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.