MySQL occasionally crashing

March 10, 2014 3k views
eli
By:
eli
Im running an ecommerce Wordpress site on a 512mb vps. I occasionally get messages that say "this page is unavailable, try again later" and MySQL occasionally crashes and I have to restart the service. Anybody know why this could be? the database is 20mb
Log In to Comment
3 Answers
joshfng March 10, 2014
I would assume that you are probably running out of memory due to running so many services on such little ram. Try resizing your droplet to 1gb and see if the problem goes away.
Reply
eli March 11, 2014
@Josh Frye

I'll give it a shot thank you! Do you know of any ways to optimize memory usage?
Reply
mail285187 March 12, 2014
I would add swap space to your server, for me, this fixed the issue I as having. https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04
How To Add Swap on Ubuntu 12.04
by Etel Sverdlov
Linux swaps allow a system to harness more memory than was originally physically available. Here's how to set up a linux swap file on Ubuntu 12.04
Reply
Have another answer? Share your knowledge.