Mysql table locked, unable to operate

If you use navicat or other tools to connect to mysql, you will find that the next operation on the table will be in a circle. Even forcing navicat to stop will not work

Why?

Because it’s not navicat at all. The mysql table is locked

The solution?

We create a new query to find all the current processes and find those that are stuck

show full processlist;
Copy the code

Then kill the corresponding process

# kill processid kill 1527Copy the code