Detecting locked tables (locked by LOCK TABLE)(检测锁定的表(由 LOCK TABLE 锁定))
|
| |
|
|
|
|
|
| | <![CDATA[<small id='wZVn0'></small><noframes id='wZVn0'>]]>
|
|
<![CDATA[<tfoot id='wZVn0'></tfoot>]]>
<![CDATA[<legend id='wZVn0'><style id='wZVn0'><dir id='wZVn0'><q id='wZVn0'></q></dir></style></legend>]]><![CDATA[<bdo id='wZVn0'></bdo><ul id='wZVn0'></ul>]]>
| |
<![CDATA[<i id='wZVn0'><tr id='wZVn0'><dt id='wZVn0'><q id='wZVn0'><span id='wZVn0'><b id='wZVn0'><form id='wZVn0'><ins id='wZVn0'></ins><ul id='wZVn0'></ul><sub id='wZVn0'></sub></form><legend id='wZVn0'></legend><bdo id='wZVn0'><pre id='wZVn0'><center id='wZVn0'></center></pre></bdo></b><th id='wZVn0'></th></span></q></dt></tr></i>]]><![CDATA[<div id='wZVn0'><tfoot id='wZVn0'></tfoot><dl id='wZVn0'><fieldset id='wZVn0'></fieldset></dl></div>]]>
| |
本文介绍了检测锁定的表(由 LOCK TABLE 锁定)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
有没有办法检测 MySQL 中的锁定表?我的意思是由 LOCK TABLE table WRITE/READ 命令锁定的表.
Is there a way to detect locked tables in MySQL? I mean tables locked by the LOCK TABLE table WRITE/READ command.
(请注意，有兴趣检测使用 GET_LOCK 获取的命名锁的读者应该阅读 改为显示来自 get_lock 的所有当前锁.)
(Note that readers interested in detecting named locks acquired with GET_LOCK should read Show all current locks from get_lock instead.)
推荐答案
SHOW OPEN TABLES 显示每个表的状态和它的锁.
SHOW OPEN TABLES to show each table status and its lock.
对于命名锁，查看 从 get_lock 显示所有当前锁
这篇关于检测锁定的表(由 LOCK TABLE 锁定)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！
