Then there are other aspects like, may be the skip-name-solve attribute turned on. If MySQL has to invest its time resolving domain names, its paying less time retrieving information. I also consider the Query strategy https://www.ralantech.com/mysql-database-health-check-consulting-service/