How to solve the problem of mysql table deletion getting stuck

The solution to mysql table deletion stuck: first execute the "show full processlist;" statement; then execute the "kill processid;" statement; finally use the kill statement to kill all ids and restart MySQL. .

Recommendation: "mysql video tutorial"

MySQL table cannot be modified, deleted, etc., stuck. How to deal with dead and locked situations.

MySQL If the data of a table is frequently modified, the table will be locked. Causing suspended animation.

For example, if you use a connection tool such as Navicat, Navicat will not respond directly and you can only force close the software, but it will still be ineffective after restarting.

Solution:

First execute:

show full processlist;  //列出当前的操作process，一般会看到很多waiting的process，说明已经有卡住的proces了，我们要杀死这些process！！

Then execute:

kill processid;  //processid表示process的id，比如kill 3301，就会将id为3301的process杀死。

Use kill to kill all ids. Then restart MySQL and it will usually be solved. If it still doesn't work, it should be impossible. . .

Restart MySQL:

net stop mysql  //停止MySQL
net start mysql  //启动MySQL

The above is the detailed content of How to solve the problem of mysql table deletion getting stuck. For more information, please follow other related articles on the PHP Chinese website!