Question

MySQL stops unexpectedly on Ubuntu with LAMP stack

Posted December 6, 2013 5k views
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?
Add a comment
mick254264
By:
mick254264

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.

×
Submit an Answer
1 answer
pablo December 6, 2013
"... two instances MySQL keeps stopping unexpectedly."

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 swap and memcache; and possibly replacing Apache w/Nginx.
How To Install and Use Memcache on Ubuntu 12.04
by Etel Sverdlov
Memcache is a system that works to speed up virtual private servers by caching server information. The program allows you to allocate a specific amount of the server ram toward caching recently queried data for a certain amount of time. This tutorial covers Memcache installation and illustrates how to use memcache with a simple php script.
Reply Report

Looking for something else?

Ask a new question Search for more help