===================================== 141204 9:47:37 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 11 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 7317 1_second, 7317 sleeps, 683 10_second, 888 background, 888 flush srv_master_thread log flush and writes: 7615 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3271, signal count 3215 Mutex spin waits 10695, rounds 66599, OS waits 1655 RW-shared spins 1344, rounds 37388, OS waits 1220 RW-excl spins 221, rounds 13458, OS waits 385 Spin rounds per wait: 6.23 mutex, 27.82 RW-shared, 60.90 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 141203 9:47:15 *** (1) TRANSACTION: TRANSACTION 7408E9, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 320, 2 row lock(s) MySQL thread id 768, OS thread handle 0x49c, query id 266471 localhost 127.0.0.1 root update INSERT INTO semaphore (name, value, expire) VALUES ('theme_registry:runtime:crisp_red:cache', '327802050547edc23bbb8a6.38654395', '1417600065.9278') *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 1154 n bits 128 index "PRIMARY" of table "newsite"."semaphore" trx id 7408E9 lock_mode X locks rec but not gap waiting Record lock, heap no 55 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 30; hex 7468656d655f72656769737472793a72756e74696d653a63726973705f72; asc theme_registry:runtime:crisp_r; (total 38 bytes); 1: len 6; hex 0000007408b9; asc t ;; 2: len 7; hex 6f000014892bc1; asc o + ;; 3: len 30; hex 34393033343839333235343765646332333932663432312e333231313735; asc 490348932547edc2392f421.321175; (total 32 bytes); 4: len 8; hex 88856610b71fd541; asc f A;; *** (2) TRANSACTION: TRANSACTION 7408E8, ACTIVE 0 sec inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 320, 2 row lock(s) MySQL thread id 767, OS thread handle 0x1f6c, query id 266470 localhost 127.0.0.1 root update INSERT INTO semaphore (name, value, expire) VALUES ('theme_registry:runtime:crisp_red:cache', '1427591620547edc23bbb588.77747125', '1417600065.9278') *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 1154 n bits 128 index "PRIMARY" of table "newsite"."semaphore" trx id 7408E8 lock mode S locks rec but not gap Record lock, heap no 55 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 30; hex 7468656d655f72656769737472793a72756e74696d653a63726973705f72; asc theme_registry:runtime:crisp_r; (total 38 bytes); 1: len 6; hex 0000007408b9; asc t ;; 2: len 7; hex 6f000014892bc1; asc o + ;; 3: len 30; hex 34393033343839333235343765646332333932663432312e333231313735; asc 490348932547edc2392f421.321175; (total 32 bytes); 4: len 8; hex 88856610b71fd541; asc f A;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 1154 n bits 128 index "PRIMARY" of table "newsite"."semaphore" trx id 7408E8 lock_mode X locks rec but not gap waiting Record lock, heap no 55 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 30; hex 7468656d655f72656769737472793a72756e74696d653a63726973705f72; asc theme_registry:runtime:crisp_r; (total 38 bytes); 1: len 6; hex 0000007408b9; asc t ;; 2: len 7; hex 6f000014892bc1; asc o + ;; 3: len 30; hex 34393033343839333235343765646332333932663432312e333231313735; asc 490348932547edc2392f421.321175; (total 32 bytes); 4: len 8; hex 88856610b71fd541; asc f A;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 75668A Purge done for trx's n:o < 756680 undo n:o < 0 History list length 1136 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 1671, OS thread handle 0x1c18, query id 494092 localhost 127.0.0.1 root show engine innodb status ---TRANSACTION 756689, ACTIVE 32 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 320, 1 row lock(s) MySQL thread id 1666, OS thread handle 0x49c, query id 494046 localhost ::1 root updating DELETE FROM cache_bootstrap WHERE (cid = 'variables') ------- TRX HAS BEEN WAITING 32 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 22288 n bits 80 index "PRIMARY" of table "newsite_2"."cache_bootstrap" trx id 756689 lock_mode X locks rec but not gap waiting Record lock, heap no 5 PHYSICAL RECORD: n_fields 7; compact format; info bits 32 0: len 9; hex 7661726961626c6573; asc variables;; 1: len 6; hex 00000075653e; asc ue>;; 2: len 7; hex 53000058aa05ad; asc S X ;; 3: len 30; hex 613a3739313a7b733a33393a226164646974696f6e616c5f73657474696e; asc a:791:{s:39:"additional_settin; (total 788 bytes); 4: len 4; hex 80000000; asc ;; 5: len 4; hex d48026e6; asc & ;; 6: len 2; hex 8001; asc ;; ------------------ ---TRANSACTION 75653E, ACTIVE 247 sec 27 lock struct(s), heap size 2496, 12 row lock(s), undo log entries 51 MySQL thread id 1658, OS thread handle 0x1f6c, query id 493965 localhost 127.0.0.1 root Trx read view will not see trx with id >= 75653F, sees < 75653F -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (read thread) I/O thread 4 state: wait Windows aio (read thread) I/O thread 5 state: wait Windows aio (read thread) I/O thread 6 state: wait Windows aio (write thread) I/O thread 7 state: wait Windows aio (write thread) I/O thread 8 state: wait Windows aio (write thread) I/O thread 9 state: wait Windows aio (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 37676 OS file reads, 173807 OS file writes, 40778 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 5, seg size 7, 16 merges merged operations: insert 79, delete mark 1587, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 444209, node heap has 21 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19845444138 Log flushed up to 19845444138 Last checkpoint at 19845444138 0 pending log writes, 0 pending chkp writes 35350 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 113688576; in additional pool allocated 0 Dictionary memory allocated 7347335 Buffer pool size 6848 Free buffers 0 Database pages 6827 Old database pages 2500 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 55442, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 37665, created 10665, written 134622 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 6827, unzip_LRU len: 0 I/O sum[14]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread id 1100, state: waiting for server activity Number of rows inserted 740820, updated 62428, deleted 50817, read 5977185 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================