We are running the standard “LAMP on Ubuntu 12.04” image on several droplets. On most droplets this works really well, but on two instances MySQL keeps stopping unexpectedly. There is very little work load on the servers where this happens. Any good tips on where I can start to look for the root of this problem?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!
<b>“… two instances MySQL keeps stopping unexpectedly.”</b> <br> <br>If they happen to be 512 MB droplets, this is actually expected behavior (b/c Apache + MySQL together eat up a lot of resources). The remedy is to add <a href=“https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04”>swap</a> and <a href=“https://www.digitalocean.com/community/articles/how-to-install-and-use-memcache-on-ubuntu-12-04”>memcache</a>; and possibly replacing Apache w/Nginx.