Solve the problem of a large number of unauthenticated users in MySQL

DocumentRun the Show Processlist statement in MySQL to find that a large number of unauthenticated user processes are stuck. Search for the root cause on the Internet:

It is found that this is a special setting on the official system and can also be called a MySQL bug. no matter whether the connection is through the hosts or IP mode, he will reverse query the DNS. MySQL will try to reverse Query IP-> DNS, because reverse query and resolution are too slow to cope with fast and massive queries.

The solution is simple: when MySQL is started, add the-skip-name-resolve option to disable domain name resolution and solve the problem.