Hi, we are using our VPS to host WordPress Themes (we are selling templates). The problem is that sometimes we get an SQL crash and the themes stop working just like that… we need to restart SQL to fix that, what may cause this? Is there any way to auto restart it?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!
you should upgrade more RAM or try this: <br> <br>http://digitaloceanvps.blogspot.com/2014/04/best-configuration-for-512mb-1gb-ram.html
<b>“… what may cause this?”</b> <br> <br>Not enough memory… <br> <br>1.) Dump Apache, for Nginx (Nginx is lighweight). <i>See</i> <a href=“https://www.digitalocean.com/community/articles/how-to-install-wordpress-nginx-php-and-varnish-on-ubuntu-12-04”>How To Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04</a>; <br> <br>2.) Add swap. <i>See</i> <a href=“https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04”>How To Add Swap on Ubuntu 12.04</a>; <br> <br>3.) Add MySQL caching. <i>See</i> <a href=“https://www.digitalocean.com/community/articles/how-to-install-and-use-memcache-on-ubuntu-12-04”>How To Install and Use Memcache on Ubuntu 12.04</a>; <br> <br>4.) Create a CDN for static files. <br> <br>5.) Install the <a href=“http://wordpress.org/plugins/w3-total-cache/”>W3 Total Cache</a> plugin.