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

This article introduces the relevant knowledge of "the solution to the problem that Aborted_connections always appear greater than 0 in mysql". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

In my database inside, I look at the Aborted_connections parameter every day, every day will be greater than 0, sometimes dozens, sometimes hundreds, in fact, I will restart the mysql library once a day, if I start twice a day will not appear Aborted_connections greater than 0, so I want to ask you, what parameters should I modify to control this value, so that it is normal? My max_connections are 1000. Solution: a few days ago I also encountered the same problem, you use the following method to restart it, I am using the following method to solve, I hope the same applies to you. When using show processlist; see the following message

unauthenticated user | 192.168.0.3:1112 | NULL | Connect | NULL | login | NULL

1. Start with parameter--skip-name-resolve

2, access to the host authorization with IP, it is best to write the host IP and host name in the/etc/hosts file

"Missing_connections always appear in mysql is greater than 0 problem solution" content introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

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.