…lock(s) MySQL thread id 31929, query id 484616 localhost root update insert into t values(33) ——- TRX HAS BEEN WAITING 34 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 16403 n bits 72 index `PRIMARY` of table `test/iz` trx id 0 42313619 lock…this line hold log sequence, all changes up to which has been flushed from buffer pool. Changes having higher log sequences may still only be…
