Retrieving Detailed Lock Information
Posted by:
Geoff Mina
Date: November 07, 2005 10:08AM
Hello Everyone... I have an InnoDB/SHOW INNODB STATUS question. I am trying to debug an application that is becomming deadlocked. In the error handling of my application I am executing a "SHOW INNODB STATUS" command against my database and logging the current state of the system for debugging purposes. I can see the thread that has the locks, but can't see any detail about what is actually locked. It usually just says something like
---TRANSACTION 0 25538077, ACTIVE 56 sec, OS thread id 1032
2 lock struct(s), heap size 320
MySQL thread id 267716, query id 63284383 192.168.10.192 root
What I want to know, is there anyway for me to ascertain what the "2 lock structs" are?
Any help is greatly appreciated!
Geoff
Subject
Views
Written By
Posted
Retrieving Detailed Lock Information
2165
November 07, 2005 10:08AM
1828
November 07, 2005 08:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.