数据库死锁解决办法

错误描述:Lock wait timeout exceeded; try restarting transaction; nested exception

解决办法:

1、SELECT * FROM information_schema.INNODB_TRX;

2、kill [trx_mysql_thread_id]

 

posted @ 2020-05-13 00:18  暹罗siam  阅读(237)  评论(0编辑  收藏  举报