As again shared on my FaceBook wall …

WordPress MySQL on Ubuntu Keeps Crashing?

uh o … high priority call coming in
from another beautiful woman
with the following problem:

“Error establishing database connection”

Not again … what could it be this time?!

Hacked? Course not! It’s an ultra badassrhyker super secure server. So what it could it be … hmzzz.

Bit of messing with settings … it’s been ages ago I done server administration … a ‘real’ nerd (I’m a poser ) can see that immediately from the history log but … problem solved AND cured the cause. At next crash? We just have to upgrade the VPS to compensate for future growth. Phewww.

And it was solved within half a hour! Let’s get down to the nuts and bolts:

Troubleshooting Digital Ocean WordPress Droplet

Here’s the syntax from the console I used to fix the issue on our 1GB RAM droplet:

At command #58 these contents have to be appended to fstab file:

 /swapfile       none    swap    sw      0       0

WP/MySQL problem status: SOLVED!

Update: with htop we monitored the results over a longer period of time, and it indeed showed it was lack of RAM memory, as the swap was used and the server kept on running.

Bibliography / appendix

Like to further background research? And/or articles we used to compile this wisdom:

• https://www.digitalocean.com/community/questions/mysql-on-ubuntu-keeps-crashing
• https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-ubuntu-12-04

• About the Author
• Latest Posts
• Community Contributor

About Earnie Rhyker

tech pioneer | intellectual BadAss | ethical lifehacker | WordPress Developer & Polyglot | information activist | blogger | added value services provider | multimedia enthusiast | senior linux server administrator | geek | bitcoin investor | laptop entrepreneur | open source contributor | hackintosh fanatic | charity donator | accredited top MLM networker & internet marketer 2014-2016 @ BFH | digital expat

• My Dutch / NL WordPress Translation contributions: October 2022 - October 9, 2022
• My Dutch / NL WordPress Translation contributions: August 2022 - August 23, 2022
• [NL] Ultra Light digital nomad Europe travel with Ryanair / Wizz Air - August 20, 2022
• My Dutch / NL WordPress Translation contributions: July 2022 - July 27, 2022
• My Dutch / NL WordPress Translation contributions: April 2022 - April 2, 2022

View All Posts

Communities I have been 'hanging out' regularly over the past two decades. 

• Nomadlist.com since 2022-04
• Empire.Kred since 2021-07
• Karma-Lab.com since 2019-01
• Invision Community since 2018-05
• Insanely Mac since 2018-02
• eGPU.io since 2017-04
• Tech Inferno since 2016-08
• forum.VestaCP.com since 2016
• WordPress.org since 2015-12
• Couch Surfing since 2014

• BitcoinTalk.org since 2014-03
• Warrior Forum since 2013-07
• Empire Avenue since 2013
• forum.OSXLatitude.com since 2011-08
• Envato (i.e. CodeCanyon) since 2011-07
• TripAdvisor since 2010-09
• MoneyMakerGroup.com since 2007-03
• HardWare.info since 2003-08
• SynthForum.NL since 2001-11
• gathering.tweakers.net since 2000-11

Note: links go to my profile on those respective sites. Connect with me if you like.

• EarnWithEarnie.io since 2022
• EarnWithEarnie.net since 2018

• BestProfitsTeam.com since 2017
• CycleClubMembers.com since 2015
• BestSTIFORPteam.com 2013-2021