SELECT b.trx_mysql_thread_id AS '被阻塞线程'

​      ,b.trx_query AS '被阻塞SQL'

​      ,c.trx_mysql_thread_id AS '阻塞线程'

​      ,c.trx_query AS '阻塞SQL'

​      ,(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(c.trx_started)) AS '阻塞时间'

FROM information_schema.innodb_lock_waits a 

JOIN information_schema.innodb_trx b ON a.requesting_trx_id=b.trx_id

JOIN information_schema.innodb_trx c ON a.blocking_trx_id=c.trx_id

WHERE (UNIX_TIMESTAMP()-UNIX_TIMESTAMP(c.trx_started)) >30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17