SQL Crash

December 10, 2013 2.4k views
gajkuba
By:
gajkuba
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?
Log In to Comment
2 Answers
pablo December 10, 2013
"... what may cause this?"

Not enough memory...

1.) Dump Apache, for Nginx (Nginx is lighweight). See How To Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04;

2.) Add swap. See How To Add Swap on Ubuntu 12.04;

3.) Add MySQL caching. See How To Install and Use Memcache on Ubuntu 12.04;

4.) Create a CDN for static files.

5.) Install the W3 Total Cache plugin.
How To Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04
by Etel Sverdlov
Varnish is an HTTP accelerator and a useful tool for speeding up a server, especially during a times when there is high traffic to a site. It works by redirecting visitors to static pages whenever possible and only drawing on the server itself if there is a need for an active process. This tutorial covers installing wordpress on a LEMP stack (with nginx instead of apache), and then installing varnish.
Reply
nhatkhoa April 21, 2014
you should upgrade more RAM or try this:

http://digitaloceanvps.blogspot.com/2014/04/best-configuration-for-512mb-1gb-ram.html
Reply
Have another answer? Share your knowledge.