MYSQL事务与锁问题处理SELECT * FROM information_schema.select * from

SELECT * FROM information_schema.INNODB_LOCKs; -- 查询锁

select * from information_schema.INNODB_LOCK_WAITS; -- 查询等待锁
 
SELECT * FROM information_schema.INNODB_TRX; -- 查询事务

select * from information_schema.processlist where id =7149 -- 根据事务中的进程id查询进程

kill 7149 -- 根据进程id杀死进程