Solve MySQL table can not query, modify, delete and other operations and appear stuck

Phenomenon: the table cannot be opened and deleted

Solution:

>show full processlist;    // List the processes, find the processes that are waiting, to kill them
......
......
>kill ID; // The ID number is the first column of "Id" listed


Read More: