to prevent this scenario and maintain your countless numbers (millions?) of users content, and your daily life easy, nothing is better than health check your MySQL. Here is a listing of 10 issues you should check to https://www.ralantech.com/mysql-database-health-check-consulting-service/