开发者

Equivalent of sp_lock, sp_who for mysql

Can an开发者_StackOverflow中文版yone please tell me what is the equivalent of sp_lock, sp_who or sp_who2 in mysql server? Basically I want to know which tables are locked due to some query and which host is holding on to those exclusive locks.

Thanks in advance


Check this site: http://www.xaprb.com/blog/2006/07/31/how-to-analyze-innodb-mysql-locks/


Not the same, but similar for sp_who:

SHOW FULL PROCESSLIST

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜