Wordpress SQL drops out

January 10, 2014 1.9k views
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.
8 Answers
It's crashing for a reason. Check the error logs, it should tell you why it's crashing:
tail /var/log/mysql.err
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.

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
@ Kamal There error log file is empty.

@ James Is there some kind of tutorial for that?
Hmm, what about the regular log file?
tail /var/log/mysql.log
It was probably killed by the kernel, check the system messages: http://stackoverflow.com/questions/624857/finding-which-process-was-killed-by-linux-oom-killer

Are there any instances of MySQL there?
Is there an update on this..?

I have the same issue.
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
Have another answer? Share your knowledge.