The solution of locking mysql table
Editor to share with you the solution that the mysql table is locked. I hope you will gain a lot after reading this article. Let's discuss it together.
The solution to locking the mysql table is as follows:
1. Violent solution
Restart MYSQL (restart the problem-solving weapon, manually funny)
2. Check the table:
Show processlist
State is locked by other queries if its status is Locked
3. Kill the process ID of unlocking the table
After reading this article, I believe you have a certain understanding of the solution to the locked mysql table. If you want to know more about it, welcome to follow the industry information channel. Thank you for reading!
