MySQL Forums
Forum List  »  InnoDB

SHOW ENGINE INNODB STATUS
Posted by: Andrea Villardino
Date: April 21, 2005 01:39AM

Hi,

anybody could me explain the meaning of TRANSACTIONS section of SHOW ENGINE INNODB STATUS?

In particular what does it mean "Total number of lock structs in row lock hash table 2"?
I suppose that it refers to the followig lines:

...
Omissis
...
---TRANSACTION 0 15082014, ACTIVE 7498 sec, process no 31689, OS thread id 132620406
2 lock struct(s), heap size 320, undo log entries 2
---TRANSACTION 0 15066625, ACTIVE 10161 sec, process no 31473, OS thread id 132575339
2 lock struct(s), heap size 320, undo log entries 1
...
Omissis
...

Is there a lock?
Why have they been active for 7498 and 10161 seconds, if I have a timeout of 100 seconds (innodb_lock_wait_timeout = 100)?
How can I find sql statements having lock problems into the binary logs?

Moreover I have a lot of following lines:

...
Omissis
...
---TRANSACTION 0 15118727, not started, process no 31870, OS thread id 132636794
MySQL thread id 54456, query id 8021931 serverxxx.xxx.xxx xxx.xxx.xxx.xxx username
...
Omissis
...

What does it mean "not started"? Why those transactions haven't started? Is it "normal"?

Thank you all in advanced.

Options: ReplyQuote


Subject
Views
Written By
Posted
SHOW ENGINE INNODB STATUS
4815
April 21, 2005 01:39AM
2028
April 25, 2005 07:10AM


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.