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

Editor to share with you an example of slow mysql connection analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

A colleague responded very slowly to the company's mysql machine today.

Directly connect to mysql locally and release more than N unauthenticated user.

Show processlist

| | 2244 | unauthenticated user | 192.168.15.238 Connect | NULL | NULL | login | NULL |

| | 2245 | unauthenticated user | 192.168.15.238 Connect | NULL | NULL | login | NULL |

With kill, after these processes are all kill, the system is normal.

I don't know what these unauthenticated user are for.

Google, use the: skip-name-resolve parameter to solve this problem.

The above is all the contents of the article "sample Analysis of slow mysql connections". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.