InnoDB Standard Monitor and Lock Monitor Output ------- TRX HAS BEEN WAITING 23 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 4 page no 4 n bits 72 index GEN_CLUST_INDEX of table ‘test‘.‘t‘ trx id 7747 lock_mode X waiting Record lock, heap no 3 PHYSICAL RECORD: n_fields 4; compact format; info bits 0  0: len 6; hex 000000000202; asc ;;  1: len 6; hex 000000001e41; asc A;;  2: len 7; hex 820000008b0110; asc ;;  3: len 4; hex 80000001; asc ;; ------------------ TABLE LOCK table ‘test‘.‘t‘ trx id 7747 lock mode IX RECORD LOCKS space id 4 page no 4 n bits 72 index GEN_CLUST_INDEX of table ‘test‘.‘t‘ trx id 7747 lock_mode X waiting Record lock, heap no 3 PHYSICAL RECORD: n_fields 4; compact format; info bits 0  0: len 6; hex 000000000202; asc ;;  1: len 6; hex 000000001e41; asc A;;  2: len 7; hex 820000008b0110; asc ;;  3: len 4; hex 80000001; asc ;; -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,  ibuf aio reads:, log i/o’s:, sync i/o’s: Pending flushes (fsync) log: 0; buffer pool: 0 833 OS file reads, 605 OS file writes, 208 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations:  insert 0, delete mark 0, delete 0 discarded operations:  insert 0, delete mark 0, delete 0 Hash table size 553253, node heap has 0 buffer(s) Hash table size 553253, node heap has 1 buffer(s) Hash table size 553253, node heap has 3 buffer(s) Hash table size 553253, node heap has 0 buffer(s) Hash table size 553253, node heap has 0 buffer(s) Hash table size 553253, node heap has 0 buffer(s) Hash table size 553253, node heap has 0 buffer(s) Hash table size 553253, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19643450 Log buffer assigned up to 19643450 Log buffer completed up to 19643450 Log written up to 19643450 Log flushed up to 19643450 Added dirty pages up to 19643450 Pages flushed up to 19643450 Last checkpoint at 19643450 129 log i/o’s done, 0.00 log i/o’s/second ---------------------- 3343