Status \===================================== 070420 17:20:12 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 35 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 24, signal count 24 Mutex spin waits 19, rounds 320, OS waits 3 RW-shared spins 42, OS waits 19; RW-excl spins 3, OS waits 2 ------------------------ LATEST DETECTED DEADLOCK ------------------------ 070420 17:14:38 *** (1) TRANSACTION: TRANSACTION 0 10429900, ACTIVE 1 sec, process no 4402, OS thread id 1116240816 starting index read mysql tables in use 1, locked 1 LOCK WAIT 9 lock struct(s), heap size 1024 MySQL thread id 1154, query id 8005 localhost muir updating DELETE FROM charm2attribute WHERE id = '112' AND pkey = 'coin1' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 58 n bits 128 index `PRIMARY` of table `rectangle/charm2attribute` trx id 0 10429900 lock_mode X locks rec but not gap waiting Record lock, heap no 44 PHYSICAL RECORD: n_fields 6; 1-byte offs TRUE; info bits 0 0: len 8; hex 8000000000000070; asc p;; 1: len 5; hex 636f696e31; asc coin1;; 2: len 6; hex 0000009f25c2; asc % ;; 3: len 7; hex 000000002d2a7e; asc -*~;; 4: len 2; hex 3235; asc 25;; 5: len 1; hex 30; asc 0;; *** (2) TRANSACTION: TRANSACTION 0 10429899, ACTIVE 1 sec, process no 4402, OS thread id 1115970480 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 9 lock struct(s), heap size 1024 MySQL thread id 1155, query id 8006 localhost muir updating DELETE FROM charm2attribute WHERE id = '112' AND pkey = 'coin1' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 58 n bits 128 index `PRIMARY` of table `rectangle/charm2attribute` trx id 0 10429899 lock mode S Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; 1-byte offs TRUE; info bits 0 0: len 9; hex 73757072656d756d00; asc supremum ;; Record lock, heap no 15 PHYSICAL RECORD: n_fields 6; 1-byte offs TRUE; info bits 0 0: len 8; hex 800000000000006f; asc o;; 1: len 5; hex 636f696e34; asc coin4;; 2: len 6; hex 0000009f25c2; asc % ;; 3: len 7; hex 000000002d2986; asc -) ;; 4: len 2; hex 3130; asc 10;; 5: len 1; hex 30; asc 0;; Record lock, heap no 42 PHYSICAL RECORD: n_fields 6; 1-byte offs TRUE; info bits 0 0: len 8; hex 800000000000006f; asc o;; 1: len 5; hex 636f696e33; asc coin3;; 2: len 6; hex 0000009f25c2; asc % ;; 3: len 7; hex 000000002d29c0; asc -) ;; 4: len 1; hex 35; asc 5;; 5: len 1; hex 30; asc 0;; Record lock, heap no 44 PHYSICAL RECORD: n_fields 6; 1-byte offs TRUE; info bits 0 0: len 8; hex 8000000000000070; asc p;; 1: len 5; hex 636f696e31; asc coin1;; 2: len 6; hex 0000009f25c2; asc % ;; 3: len 7; hex 000000002d2a7e; asc -*~;; 4: len 2; hex 3235; asc 25;; 5: len 1; hex 30; asc 0;; Record lock, heap no 45 PHYSICAL RECORD: n_fields 6; 1-byte offs TRUE; info bits 0 0: len 8; hex 8000000000000070; asc p;; 1: len 5; hex 636f696e32; asc coin2;; 2: len 6; hex 0000009f25c2; asc % ;; 3: len 7; hex 000000002d2ab8; asc -* ;; 4: len 2; hex 3130; asc 10;; 5: len 1; hex 30; asc 0;; Record lock, heap no 47 PHYSICAL RECORD: n_fields 6; 1-byte offs TRUE; info bits 0 0: len 8; hex 8000000000000071; asc q;; 1: len 5; hex 636f696e35; asc coin5;; 2: len 6; hex 0000009f25c2; asc % ;; 3: len 7; hex 000000002d2b7f; asc -+ ;; 4: len 2; hex 3530; asc 50;; 5: len 1; hex 30; asc 0;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 58 n bits 128 index `PRIMARY` of table `rectangle/charm2attribute` trx id 0 10429899 lock_mode X locks rec but not gap waiting Record lock, heap no 44 PHYSICAL RECORD: n_fields 6; 1-byte offs TRUE; info bits 0 0: len 8; hex 8000000000000070; asc p;; 1: len 5; hex 636f696e31; asc coin1;; 2: len 6; hex 0000009f25c2; asc % ;; 3: len 7; hex 000000002d2a7e; asc -*~;; 4: len 2; hex 3235; asc 25;; 5: len 1; hex 30; asc 0;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 0 10429923 Purge done for trx's n:o < 0 10429921 undo n:o < 0 0 History list length 3 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 4402, OS thread id 1139493808 MySQL thread id 1186, query id 8209 localhost root show innodb status -------- 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 (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 39 OS file reads, 536 OS file writes, 333 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 9, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 7 2032509034 Log flushed up to 7 2032509034 Last checkpoint at 7 2032509034 0 pending log writes, 0 pending chkp writes 260 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18316726; in additional pool allocated 987776 Buffer pool size 512 Free buffers 473 Database pages 38 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 37, created 1, written 331 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue Main thread process no. 4402, id 1122577328, state: waiting for server activity Number of rows inserted 1233, updated 355, deleted 1210, read 12446 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================