To avoid this state of affairs and keep your hundreds (millions?) of users pleased, and your life uncomplicated, very little is much better than health check your MySQL. Here's a list of 10 items you'll want to check to https://www.ralantech.com/mysql-database-health-check-consulting-service/