MySQL on Ubuntu Keeps Crashing

Finally this helped, none of other solution did any change (add swap, monitor for banned iP’s, upgrade droplet):

## Edit /etc/my.cnf, and add the following line under the [mysqld] heading.
[mysqld]
innodb_buffer_pool_size=64M
```

Then restart: `$  service mysql restart`

MySQL could be running out of memory - try adding swap to your droplet: <br> <br>https://www.digitalocean.com/community/articles/how-to-add-swap-on-centos-6 <br>https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04

This is a pretty common issue with WordPress, certainly not the fault of the DO preconfigured instance as I’ve experienced the same spinning up my own DO instances as well as back when I used to use AWS EC2. Moving up to an instance with more memory may help temporarily, but you’ll likely still eventually come face to face with this issue.

My sites will typically work flawlessly for several months until eventually they start to become plagued with MySQL crashes. My solution almost always ends up being spinning up a new instance and migrating over where the 2-4 month cycle just repeats itself. I’ve yet to be able to pin down the root cause or a solution.