Mysql server crashes – Digitalocean Droplet

Recently I installed MySQL on one of my servers. Everything worked fine but hours later I realized the DBMS was down.

I took a look in the log and I noticed that there was a message about memory

140124 17:29:01 InnoDB: Fatal error: cannot allocate memory for the buffer pool

If you are coming across this issue there are 3 solutions:

  • Check If you have unnecessary apps consuming your server memory and get rid of them
  • Upgrade your droplets memory
  • Enable Disk Swap  – Check this guide
    • Warning: Try to avoid Swap in SSD’s since this can have a negative impact in the drive’s lifetime

In my case, I decided to resize my droplet moving from 512mb of ram to 1024mb.

Leave a Reply

Close Menu