A problem on one of my VPS haunted me for weeks: occasionally, almost once a day, the database (MariaDB, default drop-in for MySQL on Debian) stopped to accept connections and the only way to fix was to manually kill and restart it.
A bit more of investigation resulted in a