Then there are other aspects like, may be the skip-title-resolve function turned on. If MySQL has to spend its time resolving area names, its investing a lot less time retrieving facts. I also look at the question https://www.ralantech.com/mysql-database-health-check-consulting-service/