List:General Discussion« Previous MessageNext Message »
From:Ilya Kazakevich Date:May 28 2013 1:53pm
Subject:List of locks kept by transaction
View as plain text  
Hello,

 

There is transaction that keeps several locks. 

 

(from innodb status):

 

---TRANSACTION 0 101247934, ACTIVE 2209 sec, process no 3136, OS thread id
1189648704

4 lock struct(s), heap size 1216, 1 row lock(s), undo log entries 6

MySQL thread id 7902, query id 3160394 foo.example.com t 1.2.3.4 foo-test

Trx read view will not see trx with id >= 0 101252647, sees < 0 101252647

 

How can I find which lock is held?

 

Ilya.


Thread
List of locks kept by transactionIlya Kazakevich28 May