mysql死锁解决

SELECT * FROM information_schema.INNODB_LOCKs;

SELECT * FROM information_schema.INNODB_LOCK_waits;

SELECT * FROM information_schema.INNODB_TRX; 

 

kill   trx_mysql_thread_id

 

posted @ 2020-04-01 11:05  jack_zc  阅读(310)  评论(0)  编辑  收藏  举报