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

This article introduces the mysql implementation of show processlist unauthenticated user solutions, the content is very detailed, interested friends can refer to, hope to be helpful to you.

A unibilling machine suddenly became overloaded a few days ago. It is found that cpu is heavily occupied in top. Agi programs run slowly and zombie processes appear. In fact, there were only about 50 concurrent calls at that time. It is far from the normal level. The problem of restarting the machine has not been solved. Very strange。

Considering that mysqld consumes the most resources in top, go to the mysql console, run the show processlist command, and find that the information of a process is very special:

User "unauthenticated user"

Command "connect"

Is State "reading from net" attacking my machine from internet? Obviously not, because the Host column shows "localhost".

No way out。 A search on google found that a number of people had encountered the problem. It's not a bug either, because it can be solved by changing the configuration file / etc/my.cnf.

Specifically, add skip-name-resolve to the mysqld column

[mysqld]

Skip-name-resolve

Note that skip-name-resolve can disable dns parsing, but instead of using hostnames in mysql's authorization table, only IP. Exe can be used. If you used to create a mysql user using localhost, you now need to use 127.0.0.1 instead of adding the user in the grant statement.

Then, restart mysqld.

On the implementation of mysql show processlist unauthenticated user solutions to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.