Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the problem of mysql connection too slow". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian slowly and deeply to study and learn "how to solve the problem of mysql connection too slow" together!

3 solutions (the disadvantage of the first 2 solutions is that you can no longer use the hostname, but use the IP address):

1. Add--skip-name-resolve to startup parameters to disable reverse domain name resolution

2. Add skip-name-resolve to section [d] of my.cnf

3. Add the corresponding host record to the/etc/hosts file

Thank you for reading, the above is "how to solve the problem of mysql connection too slow" content, after the study of this article, I believe that we have a deeper understanding of how to solve the problem of mysql connection too slow, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.