Question

Wordpress SQL drops out

  • Posted January 10, 2014

I have wordpress in my droplet and the SQL service drops out every few days. I’ve done everything reccomended, like adding swap, W3 Cache Plugin, and even resized my droplet to 1 GB, but still have the same problem. It’s a wordpress blog with small traffic.

Wat worries me is that I always restart the SQL service manualy. Is there a way I can make this sql restar automatic for future drop outs?

Thanks.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

Is there an update on this…? <br> <br>I have the same issue.

It was probably killed by the kernel, check the system messages: <a href=“http://stackoverflow.com/questions/624857/finding-which-process-was-killed-by-linux-oom-killer”>http://stackoverflow.com/questions/624857/finding-which-process-was-killed-by-linux-oom-killer</a> <br> <br>Are there any instances of MySQL there?

@Kamal Also empty :(

Hmm, what about the regular log file? <br><pre>tail /var/log/mysql.log</pre>

@ Kamal There error log file is empty. <br> <br>@ James Is there some kind of tutorial for that?

I had the same issue and not being an expert on Apache of MySql beyond basic setup I’ve split them up. It seems in default configuration even a 1GB droplet can’t quite cope with MySQL and Apache on the same box. <br> <br>I created two 512MB droplets in AMS2 which has private networking. One has Apache installed and one has MySQL installed with MySQL configured only to listen on in its private IP. For the same price as a 1GB droplet I’ve had approximately six months of up time without any issues

It’s crashing for a reason. Check the error logs, it should tell you why it’s crashing: <br><pre>tail /var/log/mysql.err</pre>