MySQL Forums
Forum List  »  InnoDB

how to tell which table is locked...
Posted by: patrick lau
Date: November 23, 2008 10:49AM

Dear, is there any way to know which table is locked during a transaction?
e.g.
begin
select * from foo where attr="abc" for update
....
....
commit

Then before commit, I want to know table foo is being locked.

can tool like innotop show?
Thanks!!

Options: ReplyQuote


Subject
Views
Written By
Posted
how to tell which table is locked...
2628
November 23, 2008 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.