Prevent MySQL crashing

On our support forum and GitHub issue tracker, we are seeing some are facing MySQL crashing issue. This issue is commonly observed on Digital Ocean 512 plan.

We are still working on preventing MySQL crash, below are some common points and measures observed.

Low Swap Memory

For all VPS we recommend at least 1GB swap.

How to create SWAP: https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-ubuntu-14-04

Adjusting PHP5-FPM pm.max_children:

By default EasyEngine sets this values to 100, thanks to Kym for pointing, on low RAM VPS, for high traffic PHP5-FPM takes nearly all RAM, leaving no RAM to MySQL

Change PHP5-FPM pm.max_children:
Open www.conf file:

vim /etc/php5/fpm/pool.d/www.conf

For 512MB – 1GB RAM:

pm.max_children = 10

For 2GB RAM:

pm.max_children = 20

For 4GB RAM:

pm.max_children = 50

After that you need to restart PHP5-FPM

php5-fpm -t && service php5-fpm restart

Tuning MySQL

Tuning MySQL is always good practice. You can use following command to get MySQL tuning suggestions.

  • MySQL Tunner
mysqltuner
  • Tuning Primer
tuning-primer.sh

Adjust the MySQL values as per suggestions in my.cnf file

vim /etc/mysql/my.cnf

and restart MySQL

service mysql restart

If you still facing MySQL crashing issue, we are always ready to help you, for this you can use this thread: #244