In this post I will show you how to get even more information about what is locked by a transaction.
As you might have noticed the information_schema.innodb_locks table doesn't show all locks. This is what the documentation says:
INNODB_LOCKStable contains information about each lock that an
InnoDBtransaction has requested but not yet acquired, and each lock that a transaction [Read more...]