| InnoDB | | ===================================== 140127 21:53:23 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 34 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 219 1_second, 219 sleeps, 18 10_second, 56 background, 56 flush srv_master_thread log flush and writes: 227 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 612, signal count 268 Mutex spin waits 1533, rounds 16693, OS waits 482 RW-shared spins 46, rounds 1324, OS waits 42 RW-excl spins 195, rounds 3534, OS waits 80 Spin rounds per wait: 10.89 mutex, 28.78 RW-shared, 18.12 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 140127 21:53:06 *** (1) TRANSACTION: TRANSACTION 83C9, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 9 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 2 MySQL thread id 83, OS thread handle 0x7f45e420d700, query id 35918 localhost 127.0.0.1 root Updating update USERS set VERSION=110, UUID='36367200-bf26-11e2-8099-14dae9ef6bff', FIRST_NAME='"

"', LAST_NAME='dd', USERNAME='admin', ENCODED_USERNAME='admin', EMAIL='admin@jtalks.org', PASSWORD='21232f297a57a5a743894a0e4a801fc3', LAST_LOGIN='2014-01-27 21:52:43', AVATAR=x'', ENABLED=1 where ID=1 and VERSION=109 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 617 n bits 80 index `PRIMARY` of table `jtalks`.`USERS` trx id 83C9 lock_mode X locks rec but not gap waiting Record lock, heap no 13 PHYSICAL RECORD: n_fields 17; compact format; info bits 0 0: len 8; hex 8000000000000001; asc ;; 1: len 6; hex 0000000083ab; asc ;; 2: len 7; hex 41000002021837; asc A 7;; 3: len 30; hex 33363336373230302d626632362d313165322d383039392d313464616539; asc 36367200-bf26-11e2-8099-14dae9; (total 36 bytes); 4: len 15; hex 223c6469763e48323c2f6469763e22; asc "

"', LAST_NAME='dd', USERNAME='admin', ENCODED_USERNAME='admin', EMAIL='admin@jtalks.org', PASSWORD='21232f297a57a5a743894a0e4a801fc3', LAST_LOGIN='2014-01-27 21:52:43', AVATAR=x'', ENABLED=1 where ID=1 and VERSION=109 *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 617 n bits 80 index `PRIMARY` of table `jtalks`.`USERS` trx id 83BF lock mode S locks rec but not gap Record lock, heap no 13 PHYSICAL RECORD: n_fields 17; compact format; info bits 0 0: len 8; hex 8000000000000001; asc ;; 1: len 6; hex 0000000083ab; asc ;; 2: len 7; hex 41000002021837; asc A 7;; 3: len 30; hex 33363336373230302d626632362d313165322d383039392d313464616539; asc 36367200-bf26-11e2-8099-14dae9; (total 36 bytes); 4: len 15; hex 223c6469763e48323c2f6469763e22; asc "

";; 5: len 2; hex 6464; asc dd;; 6: len 5; hex 61646d696e; asc admin;; 7: len 5; hex 61646d696e; asc admin;; 8: len 16; hex 61646d696e406a74616c6b732e6f7267; asc admin@jtalks.org;; 9: len 30; hex 323132333266323937613537613561373433383934613065346138303166; asc 21232f297a57a5a743894a0e4a801f; (total 32 bytes); 10: len 9; hex 555345525f524f4c45; asc USER_ROLE;; 11: len 8; hex 800012513d20de8b; asc Q= ;; 12: len 0; hex ; asc ;; 13: SQL NULL; 14: len 0; hex ; asc ;; 15: len 1; hex 81; asc ;; 16: len 8; hex 800000000000006e; asc n;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 8425 Purge done for trx's n:o < 841A undo n:o < 0 History list length 1782 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 82C3, not started MySQL thread id 86, OS thread handle 0x7f45e417a700, query id 33699 localhost 127.0.0.1 root ---TRANSACTION 795D, not started MySQL thread id 87, OS thread handle 0x7f45e4149700, query id 14752 localhost 127.0.0.1 root ---TRANSACTION 8403, not started MySQL thread id 79, OS thread handle 0x7f45e42d1700, query id 36207 localhost 127.0.0.1 root ---TRANSACTION 8405, not started MySQL thread id 83, OS thread handle 0x7f45e420d700, query id 36263 localhost 127.0.0.1 root ---TRANSACTION 8423, not started MySQL thread id 81, OS thread handle 0x7f45e426f700, query id 36574 localhost 127.0.0.1 root ---TRANSACTION 8402, not started MySQL thread id 80, OS thread handle 0x7f45e42a0700, query id 36241 localhost 127.0.0.1 root ---TRANSACTION 79D4, not started MySQL thread id 76, OS thread handle 0x7f45e4364700, query id 15503 localhost 127.0.0.1 root ---TRANSACTION 841B, not started MySQL thread id 77, OS thread handle 0x7f45e4333700, query id 36565 localhost 127.0.0.1 root ---TRANSACTION 77A7, not started MySQL thread id 82, OS thread handle 0x7f45e423e700, query id 12735 localhost 127.0.0.1 root ---TRANSACTION 8424, not started MySQL thread id 84, OS thread handle 0x7f45e41dc700, query id 36567 localhost 127.0.0.1 root ---TRANSACTION 72DF, not started MySQL thread id 78, OS thread handle 0x7f45e4302700, query id 2188 localhost 127.0.0.1 root ---TRANSACTION 72DC, not started MySQL thread id 75, OS thread handle 0x7f45e4395700, query id 2140 localhost 127.0.0.1 root ---TRANSACTION 8404, not started MySQL thread id 74, OS thread handle 0x7f45e43c6700, query id 36582 localhost 127.0.0.1 root ---TRANSACTION 7870, not started MySQL thread id 73, OS thread handle 0x7f45e43f7700, query id 12730 localhost 127.0.0.1 root ---TRANSACTION 83FE, not started MySQL thread id 71, OS thread handle 0x7f45ea15b700, query id 36585 localhost 127.0.0.1 root ---TRANSACTION 785B, not started MySQL thread id 72, OS thread handle 0x7f45ea12a700, query id 12688 localhost 127.0.0.1 root ---TRANSACTION 77C8, not started MySQL thread id 70, OS thread handle 0x7f45ea18c700, query id 12732 localhost 127.0.0.1 root ---TRANSACTION 77CA, not started MySQL thread id 67, OS thread handle 0x7f45b3fff700, query id 12731 localhost 127.0.0.1 root ---TRANSACTION 83F7, not started MySQL thread id 69, OS thread handle 0x7f45b3f9d700, query id 36575 localhost 127.0.0.1 root ---TRANSACTION 83FF, not started MySQL thread id 68, OS thread handle 0x7f45b3fce700, query id 36568 localhost 127.0.0.1 root ---TRANSACTION 786F, not started MySQL thread id 64, OS thread handle 0x7f45ea250700, query id 12722 localhost 127.0.0.1 root ---TRANSACTION 72DB, not started MySQL thread id 66, OS thread handle 0x7f45ea1ee700, query id 2139 localhost 127.0.0.1 root ---TRANSACTION 83F6, not started MySQL thread id 65, OS thread handle 0x7f45ea21f700, query id 36174 localhost 127.0.0.1 root ---TRANSACTION 0, not started MySQL thread id 63, OS thread handle 0x7f45ea1bd700, query id 36586 localhost root SHOW ENGINE 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 (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, 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 713 OS file reads, 955 OS file writes, 323 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 5.79 writes/s, 1.56 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 276707, node heap has 2 buffer(s) 414.52 hash searches/s, 180.14 non-hash searches/s --- LOG --- Log sequence number 62421252 Log flushed up to 62421252 Last checkpoint at 62421252 0 pending log writes, 0 pending chkp writes 258 log i/o's done, 1.38 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 137363456; in additional pool allocated 0 Dictionary memory allocated 650933 Buffer pool size 8192 Free buffers 7477 Database pages 713 Old database pages 279 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 702, created 11, written 1025 0.00 reads/s, 0.09 creates/s, 6.24 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: 713, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 20533, id 139937876064000, state: waiting for server activity Number of rows inserted 850, updated 220, deleted 34, read 95570 6.47 inserts/s, 1.50 updates/s, 0.00 deletes/s, 748.21 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================