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.