shishir
By:
shishir

"Error establishing a database connection" on a new WordPress site?

September 4, 2013 35.4k views
Hey. I created a new 512MB droplet, and used the 1-click wordpress install. I added a few plugins, and created just one page. This is a brand new site, and currently has no other content. The website was running fine a few days back, however, when I tried to load it today, I got the message: "error establishing a database connection" I rebooted the droplet through SSH, and the website started working again. A few articles in the DO community point out that this may be due to MySQL crashing because its falling short of memory. So I checked my Google Analytics account to see if there has been a sudden surge of activity on my website, and the only activity was 5 or so visitors a couple of days back. MySQL memory shortage seems like a plausible explanation, but I have difficulty believing that a 512 MB droplet is not enough to run a completely empty wordpress website and serve 5 users. I have a few questions: 1. Is 512 MB really too low to just host a blank site? Should the DB fail with 5 visitors? 2. If not, then what other factors could cause the DB to stop working? 3. How can I check the logs/ or find out for sure what the problem was? 4. Is there any way to keep a track of the droplet's memory usage? Additional information: I installed the following plugins on my WP site: - Better WP Security - Google Analytics for WordPress - WordPress SEO - Microkid's Related Posts - Disqus Comment System - Contact Form 7 - All in one Favicon I also installed a couple of other plugins, but they were deactivated. Also, the "Better WP Security" plugin is configured to create a backup of the WP DB every few days. Please help me out with this. I'd like to prevent my site from failing again.
3 comments
  • sasho2210 September 6, 2014

    If you have 512MB ram - add 1024MB swap file.

    In tutorial above swap is 256MB. Create 1024MB file like this:
    dd if=/dev/zero of=/swapfile bs=1M count=1000

  • scottrod May 24, 2015

    This seems like a common issue. I've contacted DO support sever times. First I was told it was due to noisy neighbors, then I was told it might be something wrong on my end. I guess—plugins. My 1gb ram droplet typically uses 5%-10% CPU, then randomly, every 1-4 days, my server gets hit with 80%-100% CPU spike. This is when I receive the database connection error.

    My site has low traffic. I use WP Super Cache to only dump cache once per day. I am also using serverpilot.io to manage my WP install. I've followed their suggested settings. https://serverpilot.io/community/articles/how-to-install-wp-super-cache.html

    The cache dumping time does not match the CPU spike time.

    It also seems swap is enabled.

    Running sudo swapon -s
    returns the following:
    ```Filename Type Size Used Priority
    /swapfile file 524284 0 -1

    
Any ideas?
  • o0Synn0o December 18, 2015

    Go here: http://www.thegeekstuff.com/2010/08/how-to-add-swap-space/

    Their WP image has no swap so memory gets used up 100% and causes mysql to crash. I wonder if it's the same for their other images.

    DigitalOcean #nochill

Log In to Comment
38 Answers
kamaln7 MOD October 17, 2013
@Dave: Is MySQL running? sudo service mysql status

Was it working fine previously?
Reply
dahunsilanre November 16, 2013
Hi Everyone, please I need help:

When i try to access myipaddress/phpmyadmin i get the following error:

phpMyAdmin - Error
The mysqli extension is missing. Please check your PHP configuration. Documentation

I just recently moved 2 sites to the digital ocean droplet (2GB, 40GB Ubuntu droplet) and the frontend of the site is showing error connecting to database.

Please help, very urgent.
Reply
eric September 4, 2013
We are having the same issue and are thinking about WPEngine to solve these headaches. One suggestion was to use nginix on DO as well.
Reply
pennywise September 5, 2013
It can be result of high load and MySQl crash. I use script to check couple of services every 5 minute if they are running, and start/restart them if they don't. You can use "monit" I think there is tutorial here how to install it.
Reply
  • beitisetiawan November 23, 2014

    Can you give me/us the example script of it? The script to control and check couple of services every 5 minute if they are running, and start/restart the system.

    Thanks

studio September 5, 2013
512 droplet is definitely enough to host a wordpress website. Mine is on a 512 droplet, never experienced any issues. I'd suspect the problem might be related to one of the plugins leaking memory.
Reply
shishir September 5, 2013
@Goran: Possibly. Is there any way to check if this is the case, and which plugin could be the culprit?
Reply
studio September 5, 2013
First I'd check any plugins doing backups. Schedule a backup from the plugin and check if that's the issue. Sometimes backup plugins can use a lot of memory.
Next I'd disable the plugins one by one and test the website performance. If you find a certain plugin to be the one causing the issues, disable it and seek alternative if you must have its functionality.
If you'd like to get a deeper insight I'd install New Relic to check what's consuming memory.
By the way, which php5 modules are you running? Which apache2 modules do you have installed? I'm asking because I don't know which ones are installed using the 1-click install and you may have some modules that are unnecessary.
Reply
studio September 5, 2013
See here: http://wordpress.org/support/topic/plugin-better-wp-security-uses-up-a-lot-of-memory

also make sure you have swap and if not do it https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04
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
kamaln7 MOD September 5, 2013
Apache uses a lot of memory by default, especially if you have a lot of plugins/themes installed. This wouldn't leave a lot of memory for MySQL and would cause it to crash.

Try adding some swap to your droplet:

https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04
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
shishir September 5, 2013
@Goran: Thanks for the suggestions. I ended up creating a larger droplet, mainly because I'm certain that I will install more plugins on my site, and some more software on my server.

@Goran, @Kamal: I had an extensive chat with DO support today. They told me that DO VPS no longer support swap. The article is outdated, and is going to be removed.
Reply
JWH3180 September 25, 2013
I was having a the same issue however I have two wordpress sites with no plugins and few visitors. Upgrading to 1GB does resolve the issue but after that I signed up to New Relic and installed their PHP monitoring tool and server monitoring tool. I am still working through the results but it's looking more and more like Apache is the cause of the issue in so far as it after only a few hours it's sucked up nearly all available memory.
Reply
stas October 3, 2013
I am having the same issue on a new droplet with just a couple of WP plug-ins. Is there a way to monitor the situation and restart MySQL if it's down?
Reply
kamaln7 MOD October 6, 2013
@stas: I recommend adding swap to your droplet (see the links above). That should prevent MySQL from crashing.
Reply
davidshq October 16, 2013
I've been having this issue as well - and adding swap hasn't resolved it.
Reply
raghav280392 November 17, 2013
The problem may be due to high memory usage and you may not have created the swap file for efficients memory management. Follow the link to get the procedure to create swap file

http://teknosrc.com/mysql-linux-ubuntu-crashing-create-swap-space-memory-solution/
Reply
subhra44 February 19, 2014
Are you guys able to fix the issue? I am facing a similar problem.
Reply
subhra44 February 19, 2014
Added swap. But how swapped memory gets freed up?
Reply
german March 25, 2014
Confused

I have a fresh installation of wordpress, on one 512mb droplet, and no traffic or little traffic, First time I have the error in 2 months

-No extra plug ins
-Askimet activated
-No extra themes, only the default twenty fourteen
-I have swap added
-Using webmin

On the other hand I have another 1gb droplet, And i get same error but more often, some traffic but not much

-Custom theme
-some plug ins
-w3 cache
-I have swap
-iredmail installed

@kamal or anybody that has a solution ?
Reply
2014nian April 8, 2014
After power cycle all database connect error,restore the backup also can not connect.how to solve it?
Reply
kamaln7 MOD April 13, 2014
Looks like MySQL is crashing/running out of memory. If you've already added swap, you might need to upgrade your droplet to get more memory or you could try optimizing MySQL's configs to use less memory.
Reply
nizamsys February 4, 2015

Please change it to mariadb. Mysql leaking memory.

Reply
varange February 13, 2015

I have an 80GB droplet with a quad-core processor and still have these issues. I suspect it may relate to some plugin, but to isolate that across about 12 domains is just too much.

So for the time being I restart Apache every 10 minutes and MySQL every 30 minutes from a cron job.

Thinking about installing nagios to monitor the droplet but it's a lot of work to configure nagios.

Reply
thegioibongdaso March 27, 2015

i have smae as problem ,this is my site Example link is alway ...

Reply
monaya April 17, 2015

wow it's 2015. I'm having the same exact problem. Brand new wordpress was working just a few days ago and now it's completely down with this error message.

It's ridiculous to believe that a simple wordpress site with no traffic would cause the server to run out of memory.

The whole point of using DO is for speed and now it can't even handle a simple wordpress site.

It took hours to figure out how to get up and running with DO and now I'm back to square one.

I have to go to WPengine instead.

What a headache.

Reply
karlonC May 4, 2015

Yea 2015 this is bad I have swap enabled and the same thing is happening. I am thinking A Small Orange Tree as a host.

Reply
mail672984 May 15, 2015

Here is the same on acreggianafemminile.it
We need to restart mySQL at least one time a day.
Please help!

Reply
me153236 May 19, 2015

I have 1 gb memory still have same problem

Reply
magicalray October 13, 2015

We need a more friendly company for this type of hosting. I know one is in the work in due time. This is system wide and annoying.

Reply
  • customeroticbak November 9, 2015

    Same problem, Google webmaster tools always has to notify me that the server is down. I upgraded the server. I did a memory swap. No idea what to do. Seems like this is common enough that DO should address it

cylehunter33 November 20, 2015

I was running into a similar issue. Upon reboot the /var/run/mysqld directory seemed to vanish. See https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1435823 for more detail.

Reply
wajoan December 4, 2015

same here on a brand new fedora 23 wp installation with mariadb. Runs just a few hours. Only "solution" for me was crontab restarts

Reply
jaapgrolleman December 9, 2015

Same here, it's really frustrating and costly to pay programmers if they cannot find a solution but blame it on the hosting by DigitalOcean. Please comment on this, DigitalOcean.

Reply
donorlynkjosh December 16, 2015

I'll just add to the chorus that I'm having the same issue. Sounds exactly like what the rest of you are experiencing. Fortunately a quick reboot fixes things, but it seems to be cropping up more often lately.

Reply
michaelpakho March 2, 2016

Same issue still happening in 2016!! I am going to host Wordpress site not in DO anymore

Reply
siteslicer April 6, 2016

Same problem on my end - I've got a Vanilla Wordpress install with a few plugins, almost no content and no visitors. The site crashes every few days with a MySQL database error.

This is on a 1gb memory Droplet using the Wordpress 1-click install on Ubuntu....so far everything I've heard from support is that it's on my end and I have to fix it.

Reply
erik.gyepes August 3, 2016

Same problem here as well, going to setup crontab restarts, as I cannot handle it anymore.

Reply
1stnas August 16, 2016

Problem solve with this code.. Very simple :)

sudo start mysql

Reply
info881540f9437 January 2, 2017

same problem here.
Every day, some days more that once "error establishing a database connection "

Reply
DaGovernor April 15, 2017

Yup: I have been having this exact same problem lately. A site that is hardly in use and not public (never been indexed by search engines) and only ever accessed by 2 people.

Lately, it has been so frequent it is a joke. I have run droplets with 512 MBs before with WordPress with no issues. This is the first time that i see this.

DO should address this issue or offer a solution as so many people have already reported before.

Reply
Have another answer? Share your knowledge.