Increase site speed for wordpress site and eliminate error establishing connection to database
I have a 10gb droplet running a wordpress site. I've always had the 'error establishing connection to database' error, which I discovered came from mysql crashing (no idea why). Every time it happens I have to restart mysql and the site comes back online. I figured it was due to low memory and followed the swap file tutorial -- still have the problem.
Additionally, the site has significantly increased in traffic (10x growth in the past week) but still under 5k visits a day. This has resulted in site slowdowns and a higher frequency of the database error (up to 5 times a day, unbelievably frustrating) Should I upgrade my droplet to a larger size? How can I increase site speeds and eliminate the database error (all login credentials in wp-config are correct).
Immediately: You need to identify why MySQL is crashing. Does syslog contain any useful information about the shutdown?
Do you know how I can access syslog via ssh? I can post any error messages.