mysql-抓取锁的几条sql语句
select r.trx_id waiting_trx_id,
r.trx_mysql_thread_id waiting_thread,
r.trx_query waiting_query,
b.trx_id blocking_trx_id,
b.trx_mysql_thread_id blocking_thread,
b.trx_query blocking_query
FROM information_schema.innodb_lock_waits w
INNER JOIN information_schema.innodb_trx b ON
b.trx_id = w.blocking_trx_id
INNER JOIN information_schema.innodb_trx r ON
r.trx_id = w.requesting_trx_id;
select
r.trx_id waitting_trx_id,
r.trx_query waitting_query,
r.trx_mysql_thread_id waitting_thread,
b.trx_id blocking_trx_id,
b.trx_mysql_thread_id blocking_thread,
b.trx_query blocking_query
from information_schema.innodb_lock_waits w
inner join information_schema.innodb_trx b
on b.trx_id=w.blocking_trx_id
inner join information_schema.innodb_trx r
on r.trx_id=w.requesting_trx_id;
select
trx_id 'InnoDB存储引擎内部唯一的事务ID' ,
trx_state '当前事务的状态',
trx_started '事务的开始时间',
trx_wait_started '事务等待的开始时间',
trx_mysql_thread_id '线程id',
trx_query '事务运行的sql语句'
from information_schema.innodb_trx；
select
lock_id '锁的id',
lock_trx_id '事务id',
lock_mode '锁的模式',
lock_type '锁的类型',
lock_table '要枷锁的表',
lock_index '锁的index',
lock_space '表空间的id',
lock_page '被锁住的页的数量',
lock_rec '被锁住的记录数',
lock_data '被锁住的行的主键值'
from information_schema.innodb_locks；
select
requesting_trx_id '申请锁资源的事务id',
requested_lock_id '申请锁的id',
blocking_trx_id '阻塞的的锁id'
from information_schema.innodb_lock_waits;
创建时间：2021-12-22 10:56
넶浏览量：0
