摘要:
#查询是否锁表 show OPEN TABLES where In_use > 0; #查看所有进程 show processlist #kill kill 288607; #查看正在锁的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 阅读全文
posted @ 2020-03-10 14:39
Suckseedeva
阅读(189)
评论(0)
推荐(0)
摘要:
#查询是否锁表 show OPEN TABLES where In_use > 0; #查看所有进程 show processlist #kill kill 288607; #查看正在锁的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 阅读全文
posted @ 2020-03-10 14:39
Suckseedeva
阅读(189)
评论(0)
推荐(0)
|