ryan1
By:
ryan1

MySQL drops out every few days?

September 26, 2012 12.8k views
So I have followed the tutorial to Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04. The process was smooth and easily installed, so no problems there. The issue is every few days the MySQL connect drops out and when I run the command: $ sudo service mysql start I get a the following message: $ start: Job failed to start The other issues is when it first happened, I looked into setting up a script to run in cron every 5 minutes. # CHECK DATABASE STATUS # launch-mysql.sh ps auxw | grep mysql | grep -v grep > /dev/null if [ $? != 0 ] then sudo service mysql start > /dev/null fi Then added this to $ cron -e */5 * * * * ~/launch-mysql.sh But that is not working either, any thoughts or help would be greatly appreciated.
3 comments
  • cepjewel September 6, 2014

    I am getting the same problem! My Server Mysql stop working few times a day

  • talaviram October 5, 2015

    same here :) fails after a few days providing the "Error establishing a database connection"

  • kamaln7 MOD October 5, 2015

    @talaviram MySQL is most likely crashing because it's running out of memory. You can add swap to your droplet which should help with that:

    If MySQL still crashes with a swapfile, you might have to upgrade your droplet to a plan with more RAM.

    How To Add Swap on Ubuntu 14.04
    by Justin Ellingwood
    Swap space can be used as an "overflow" area for your system when you run out of RAM. The operating system can store data that would normally be kept in RAM on the hard drive in a specially formatted file. In this guide, we'll demonstrate how to create and use one of these files in Ubuntu 14.04.
Log In to Comment
10 Answers
silvio September 26, 2012
Hey,
Try to start it again and then check your logs:

tail /var/log/mysql.err
tail /var/log/mysql.log
dmesg | grep mysql

It should say what's wrong, and why it's not starting :)
Reply
moisey MOD September 26, 2012
Your virtual server is most likely running out of resources you can resize to a larger server or add swap.

We added articles on how to add swap to the community section.
Reply
iwan.buetti October 3, 2012
I have the same problem, i tryied to resize the VPS from 500mb to 1000mb, but MySQL refuses to start...
Reply
ryan1 October 4, 2012
Sorry for the late reply. It seems to be working after a hard reboot.

Silvio - Thanks for the advice but unfortunately the logs where empty.

Raiyu - The Community section REALLY needs a Search function, it becomes to time consuming to navigate and find answers. Can you please provide the link to the add swap article?
Reply
moisey MOD October 4, 2012
Here are the links to the articles on how to add Swap in both Ubuntu and CentOS

https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04

https://www.digitalocean.com/community/articles/how-to-add-swap-on-centos-6

Thanks for the suggestion on search for the community, it's already in the works along with auto-search for users when you open up a ticket which will display articles and forum entries which may have info on how to solve an issue.
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
ryan1 October 4, 2012
Thanks :) And good to know that search is in the pipeline.
Reply
damian July 23, 2013
Setting up the swap fixed it for me.
Reply
nurudinjauhari February 3, 2014
How to HARD REBOOT?
Reply
fabiorosabm February 14, 2014
I had same problem, setting up the swap fixed it for me.
Reply
ginfuru November 20, 2014

Swap fixed my issues

Reply
Have another answer? Share your knowledge.