Mysql查询锁表事务，并且kill

#查看锁表进程
select * from information_schema.processlist where state like ‘Locked%’

kill ${process_id}

#5.7
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
#8.0以上
SELECT * FROM performance_schema.data_locks;

show PROCESSLIST;

参考：
https://blog.csdn.net/oqzuser12345678999q/article/details/129731318