Aikesheng Open Source Community

Apr 2, 2022 · Databases

Understanding MySQL Host Cache and skip_name_resolve Impact on Performance

The article analyzes a production issue where slave connections were slow due to missing skip_name_resolve, explains MySQL's reverse DNS resolution and host cache mechanisms, compares related parameters, shows how to inspect the host_cache table, and concludes that proper host cache settings can slightly improve MySQL performance.