Every 2 hours or so, I get a notification that MySql is down, and then all of the sites go down. All of the sites when accessed have the “Bad Gateway” page. When this happens, I also cannot access the Virtualmin Panel, and often cannot SSH in, forcing me to reboot from the VPS hosting panel. After I reboot, everything is fine for a couple of hours. I can’t find anything in logs, but perhaps I am looking in the wrong place.
I’ve had low resource problems before, but never like this. The only thing that changed before this started happening, is that I removed a bunch of old PHP versions.
I looked a bit more closely. It turns out that one of 15 accounts had not had the PHP choice explicitly set. The Virtualmin Form showed PHP8.0, but I have not yet chosen that for any account, which means that the form defaulted to the latest, but in actuality, the account was still set for the non-existent 7.2. I explicitly set the PHP to 7.4 for that account, and rebooted, and all of the 7.2 processes were gone. I am holding my breath that this actually solves the problem, but so far so good…