Shulou(Shulou.com)06/01 Report--

Editor to share with you what to do if mysql deletes the table and gets stuck. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql delete table stuck solution: first execute the "show full processlist;" statement; then execute the "kill processid;" statement; finally, use the kill statement to kill all id and restart MySQL.

MySQL table can not be modified, deleted and other operations, the treatment of jam and lock.

If MySQL frequently modifies the data of a table, then the table will be locked. Causing a fake death.

For example, if you use connection tools such as Navicat, Navicat will not respond directly and can only be forced to shut down the software, but it will still be invalid after restart.

Solution:

First execute:

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

Then execute:

Kill processid; / / processid means that the id of process, such as kill 3301, will kill the process with an id of 3301.

Use kill to kill all id. Then restart MySQL, and it will generally be solved. If not, it should be impossible.

Restart MySQL:

Net stop mysql / / stop MySQLnet start mysql / / start MySQL to finish reading this article, I believe you have a certain understanding of how to delete the table stuck in mysql, want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.