1、查询是否锁表
show OPEN TABLES where In_use > 0;
2、查询进程
show processlist
查询到相对应的进程===然后 kill id
补充:
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
1、查询是否锁表
show OPEN TABLES where In_use > 0;
2、查询进程
show processlist
查询到相对应的进程===然后 kill id
补充:
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
暂无评论
2023-11-13
2023-11-13
2023-11-13
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-05-31
2024-05-31
2024-05-31
2024-05-31
2024-05-31
2024-05-17
2024-04-19
2024-04-19
2024-03-29
2023-12-12
2023-12-12
2023-12-12
2023-12-12