|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 18.104.22.168 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.
|• List of locks kept by transaction||Ilya Kazakevich||28 May|