to prevent this scenario and maintain your 1000's (thousands and thousands?) of people happy, and your lifetime easy, practically nothing is a lot better than health check your MySQL. Here's a listing of ten points it https://www.ralantech.com/mysql-database-health-check-consulting-service/