MySQL crash with Fatal error: cannot allocate memory for the buffer pool
It’s clearly a
out of memory problem. But what to do other than adding physical memory?
- Add swap swap is your virtual memory on hard disk that can store memory content that can’t fit in your physical memory [bash] sudo fallocate -l 4G /swapfile sudo chmod 600 /swapfile sudo mkswap /swapfile sudo swapon /swapfile [/bash]
Also add to file
/etc/fstab this line
/swapfile none swap sw 0 0
So that it’s enabled after reboot.
Source: How To Add Swap on Ubuntu 14.04
- Reduce MySQL bufffer size
This might not be a good idea. Unless you understand clearly the load and requirement of your server, don’t reduce the default buffer size for MySQL.
Create a MySQL conf file in
/etc/mysql/conf.dand add the lines
[mysqld] innodb_buffer_pool_size = xxxM