mysql1213错误表锁死 mysql 1213 deadlock found when trying to get lock try restarting

错误：mysql 1213 deadlock found when trying to get lock try restarting transaction

1.检查被占用的表：

show OPEN TABLES where In_use > 0;

2.显示进程：

show processlist;

3.杀死挂起的进程即导致表锁死的进程：

kill 17909;---17909是进程的id