Report this

What is the reason for this report?

SQL Crash

Posted on December 10, 2013

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?



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

<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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.