Hello community!
My digital ocean server with Webmin/Virtualmin runs a single WordPress site. The MySQL service has been intermittently going down and I’m trying to troubleshoot why.
Here’s my settings, which are the default for a 2GB RAM install:
To keep it up, I have simply been manually restarting the service. Not a great solution but since the load is intermittent it has been OK. I’d like to dig deeper but I’m not sure how. I can upgrade the hardware if needed, but I’d rather not. Is there a way to cap CPU, RAM, and/or Disk usage for MySQL so it just acts more slowly instead of just completely failing?
12-24+ load on a 1 core vCPU, which is actually only a half cpu(1 thread). That shouldn’t be above a 1.0 load for that setup.
Have you checked the top and iotop commands during those times to see what process is causing the load. Specifically the wa%. Which is the disk wait time. If that is high, cpu load will continue to climb. The sql crash could just be a result of running out of ram becasue of some other process.
It’s been steady since 5 days ago, however today it went down again and I was able to check top. Here’s a screenshot. I’ve blanked out the user for the website owner of the affected site to protect privacy. Please let me know your thoughts. Thanks!