MySQL table can not be modified, deleted and other operations, card dead, lock the situation of processing methods.

MySQL If you frequently modify the data of a table, then this table will be locked. Cause the phenomenon of suspended animation.

For example, with Navicat and other connection tool operation, Navicat will not respond directly, can only force shutdown software, but the restart is still invalid.

Workaround:

First Execute:

Show full processlist; List the current operation process, you will generally see a lot of waiting process, indicating that there are already stuck proces, we want to kill these process!!

Re-execution:

Kill ProcessID; ProcessID indicates that the process ID, such as Kill 3301, kills the process with ID 3301.

Use Kill to kill all the IDs. Then restart MySQL, which will usually be resolved. If not, it should be impossible ...

To restart MySQL:

net stop MySQL//stop MySQL

net start MySQL//start MySQL

MySQL table can not be modified, deleted and other operations, card dead, lock the situation of processing methods.