一、查询PG_STAT_ACTIVITY的信息
SELECT * FROM pg_stat_activity where datname='bms' and wait_event_type='Lock'
二、通过pid解锁死锁信息
select pg_cancel_backend("死锁那条数据的pid值")
一:检查是否锁表, 查询进程并杀死进程
show open tables where in_use > 0;
show processlist;
show full processlist;
kill id
二:查看在锁事务,杀死事务对应的线程ID
select * from information_schema.INNODB_LOCKS;
kill ID
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
SHOW PROCESSLIST;
mysql -uroot -e 'Show processlist'
mysqladmin processlist
Original: https://www.cnblogs.com/yisk/p/16280003.html
Author: yisk
Title: 数据库锁表及解锁
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/569257/
转载文章受原作者版权保护。转载请注明原作者出处!