Using show processlist, I found that the database connection has been Reading from net, what should I do?

nimasia1

Using show processlist, I found that the database connection has been Reading from net, what should I do?
http://dev.mysql.com/doc/refman/4.1/en/show-processlist.html
Reading from net
The server is reading a packet from the network.

The explanation from the mysql official website is as above, but I don't know how to avoid this phenomenon?
And what is the reason for this phenomenon?

noendenergy

can not avoid.

nimasia1

But why is this happening?
If it is used normally, it should be used up and go to sleep.
If this happens all the time, the CPU will be very busy

nimasia1

Top oneself

yanses

up

yynst2

This is a special setting on an official system, just treat it as a bug in mysql
Regardless of whether the method of linking is through hosts or IP, it will do a reverse check on DNS
mysqld will try to reverse-check IP -> dns. Because the reverse-check resolution is too slow, it will not be able to cope with excessive queries.



Solution:

/usr/local/mysql/bin/mysqld_safe --skip-name-resolve --user=mysql&

Just add --skip-name-resolve such a parameter, turn off the dns reverse check function of mysql.