死锁解决方案

#查看事物等待情况

 1 SELECT
 2 r.trx_id waiting_trx_id,
 3 r.trx_mysql_thread_id waiting_thread,
 4 r.trx_query waiting_query,
 5 b.trx_id blocking_trx_id,
 6 b.trx_mysql_thread_id blocking_thread,
 7 b.trx_query blocking_query
 8 FROM
 9 INFORMATION_SCHEMA.INNODB_LOCK_WAITS w
10 INNER JOIN information_schema.innodb_trx b ON b.trx_id = w.blocking_trx_id
11 INNER JOIN INFORMATION_SCHEMA.innodb_trx r ON r.trx_id = w.requesting_trx_id;
View Code

 

#查看事物情况

select * from INFORMATION_SCHEMA.INNODB_TRX;
View Code

 

#查看锁情况

1 select * from INFORMATION_SCHEMA.INNODB_LOCKS;
View Code

 

#查看锁等待情况

1 select * from INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
View Code

 

#显示所有进程

1 SHOW FULL PROCESSLIST;
View Code

#显示 innode 的状态

1 SHOW ENGINE INNODB STATUS;
View Code

 

posted @ 2018-08-03 14:30  技术小白袁朋  阅读(143)  评论(0)    收藏  举报