MySQL keeps crashing on 512MB Droplet

miguelalcaino - thanks for suggesting htop. I can see that currently I’m using about 1% CPU, 148/490 RAM, and my Swap uses 55/255 (as MySQL is up and running). Are those numbers supposed to match up 512 together? Otherwise that’s probably the cause.

sierracircle - Thanks for pointing those out. I’ve made sure not to have any phpMyAdmin folder present, and I’m running my own theme which utilize very little WP functionality. Also, traffic is low (below 100 visitors / day). Reg brute force attacks, I haven’t actually looked into that. Will try the plugin you mentioned and see if there might be any issues.

Hello,

I remember I have seen a similar topic before and there, the reason for crash was a large swap… So by any chance do you have a very large swap file ??

Thanks…

You may also want to try a different theme…maybe just one of the default WordPress themes. Sometimes developers will write some hefty functions into themes that can cause problems.

I run several different droplets that are 512mb, WordPress sites on each of them with no problems. I did have to hunt down an issue on one of the droplets, but it turned out to be a wp-cron.

Also, there are couple of other things to check:

How much traffic does your site get? Do you have analytics installed so you can look at that?

Do you do anything to guard against brute-force attacks? If not, you should at least use login-lockdown plugin, which can help. It will also log any false attempts to login.

If you install that plugin, and then look in the settings an hour later and see tons of login attempts, then that could be a problem (but there are solutions…)

Also, do you have any other applications installed like phpMyadmin? Just to get a full picture of what is going on.

And finally, here is a script that will restart MySQL for you if it goes down:

https://github.com/sierracircle/services-checker

that will not solve your problem, but it will at least keep your website up while you trouble-shoot.