Date: 03/04/06 (MySQL Communtiy)    Keywords: mysql, sql

Does anybody know method to view all locks, hold by concrete thread?
"show engine innodb status" shows only "waiting for this lock"...
I need info such as "Last detected deadlock"(part "holds these locks:"), but for each current thread.
Can't find that neither standard man or "mysql internals"...

Source: http://community.livejournal.com/mysql/87708.html