MySQL database table card dead Solution

---restore content starts---

Cause of the problem:

The MySQL thread was not terminated and the table could not be opened and manipulated because the program was unexpectedly terminated when a large number of insertions were performed

-The solution is to find the waiting thread and kill

--View All processes

1, SHOW processlist;

2. Find the card dead or wait on the thread, kill, assuming here is 49496 stuck dead

KILL 49496;

---restore content ends---

MySQL database table card dead Solution