mysql:forcing close of thread xxx User: ' Root ' workaround

MySQL server suddenly hangs up at noon. Restart MySQL is also full of failures, only restart the computer to solve, but re-installed MySQL is not, night or hang,

To see MySQL's errorlog, you can only see information similar to the following:

Forcing close of thread xxxxx User: ' Root '

After Baidu

Found that this is a MySQL bug, regardless of whether the connection is through the hosts or IP, MySQL will do the DNS counter-check, IP to DNS, due to the inverse of the slow speed (whether it is a DNS server provided by the ISP or other reasons), a large number of queries will be difficult to cope with, The thread is not enough to increase the thread, but it is not released, so MySQL will be "suspended animation."

The solution is simple, to end this counter-check process, prohibit any parsing.

1. Open the MySQL configuration file (my.cnf) and add a line under [mysqld]:

Skip-name-resolve

2, the content added in My.ini:

　　Skip-locking

Skip-name-resolve

Task Manager restart MySQL service to

I do not know why, I add this: skip-locking parameter after the service cannot be started, only one skip resolution can be started, to be resolved

mysql:forcing close of thread xxx User: ' Root ' workaround