show status like '%lock%';

事务锁情况

select * from information_schema.innodb_locks;

锁表语句查询

select * from information_schema.innodb_trx
https://blog.csdn.net/zc474235918/article/details/72731363