This article mainly introduces two solutions to the MySQL error Forcingcloseofthread. For more information, see the recent increase in website traffic. some channel programs may have problems, this causes the Forcing close of thread 28790 user error in the MySQL database. How can we solve this problem? Icech finds two solutions:
1. modify the mysql configuration file
If the configuration file is my. ini, you can add the following two content in my. ini:
Skip-locking
Skip-name-resolve
Note: In the new mysql version, skip-locking has been replaced by skip-external-locking. if you use skip-locking, the following error may be reported:
[Warning] '-- skip-locking' is deprecated and will be removed in a future release. Please use '-- skip-external-locking 'Instead.
Check the logs. Therefore, the new mysql version should be written as follows:
Skip-external-locking
Skip-name-resolve
2. set in mysql service
Choose "start"> "run"> "services. msc". find the mysql service and double-click the "Restore" tab.
First Failure: The default value is "no operation", which is changed to "restart service ".
In the following "restart the service: () minutes later," 0 "indicates that the service will be restarted immediately if it is accidentally terminated.
Click OK to make the settings take effect.
However, there is a problem: if you do this, you cannot end the mysql-nt process in the task manager. If you need to stop the process, change it back before you can perform the operation.