MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

show innodb status : trx read iew will not see trx
Posted by: sebastien lecornet
Date: May 18, 2009 05:26AM

Hi,
this is the result of a show innodb status :

MySQL thread id 725, query id 41935852 host01 10.25.xx.xxx base73250
---TRANSACTION 10 440552636, ACTIVE 5106 sec, process no 17714, OS thread id 2612579248
MySQL thread id 42430, query id 39295809 host01 10.25.xx.xxx base63675
Trx read view will not see trx with id >= 10 440552637, sees < 10 433074481
---TRANSACTION 10 440518600, ACTIVE 5784 sec, process no 17714, OS thread id 2675219376
MySQL thread id 998, query id 41618332 host01 10.25.xx.xxx base63639
---TRANSACTION 10 440358399, ACTIVE 7698 sec, process no 17714, OS thread id 2572401584
MySQL thread id 3383, query id 41935858 host01 10.25.xx.xxx base73250
---TRANSACTION 10 440329056, ACTIVE 7960 sec, process no 17714, OS thread id 2719439792

What means "Trx read view will not see trx with id >= 10 440552637, sees < 10 433074481" ?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
show innodb status : trx read iew will not see trx
3867
sebastien lecornet
May 18, 2009 05:26AM


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.