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  


There is transaction that keeps several locks. 


(from innodb status):


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

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

MySQL thread id 7902, query id 3160394 t foo-test

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


How can I find which lock is held?



List of locks kept by transactionIlya Kazakevich28 May