===================================== 2017-01-04 15:55:21 7f05e6bfa700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 36 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 38 srv_active, 0 srv_shutdown, 966 srv_idle srv_master_thread log flush and writes: 1004 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 310 OS WAIT ARRAY INFO: signal count 373 Mutex spin waits 67, rounds 1060, OS waits 23 RW-shared spins 205, rounds 7650, OS waits 255 RW-excl spins 3, rounds 1754, OS waits 25 Spin rounds per wait: 15.82 mutex, 37.32 RW-shared, 584.67 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2017-01-04 15:39:28 7f05e6c7c700 *** (1) TRANSACTION: TRANSACTION 3829, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 16 lock struct(s), heap size 2936, 22 row lock(s), undo log entries 71 MySQL thread id 1, OS thread handle 0x7f05e6cbd700, query id 1370 172.17.0.1 mysql update insert into EventTypes (InstanceId, element) values (5, 'timer') *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 57 page no 4 n bits 72 index `FK_nrecj4617iwxlc65ij6m7lsl1` of table `sample`.`EventTypes` trx id 3829 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) TRANSACTION: TRANSACTION 3832, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 16 lock struct(s), heap size 2936, 22 row lock(s), undo log entries 71 MySQL thread id 2, OS thread handle 0x7f05e6c7c700, query id 1375 172.17.0.1 mysql update insert into EventTypes (InstanceId, element) values (6, 'timer') *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 57 page no 4 n bits 72 index `FK_nrecj4617iwxlc65ij6m7lsl1` of table `sample`.`EventTypes` trx id 3832 lock mode S Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 57 page no 4 n bits 72 index `FK_nrecj4617iwxlc65ij6m7lsl1` of table `sample`.`EventTypes` trx id 3832 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 4093 Purge done for trx's n:o < 4065 undo n:o < 0 state: running but idle History list length 517 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 16, OS thread handle 0x7f05e6bfa700, query id 1659 172.17.0.1 mysql init SHOW ENGINE INNODB STATUS ---TRANSACTION 0, not started MySQL thread id 15, OS thread handle 0x7f05e6cbd700, query id 1639 localhost root -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (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 173 OS file reads, 2981 OS file writes, 1624 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 276671, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 3839381 Log flushed up to 3839381 Pages flushed up to 3839381 Last checkpoint at 3839381 0 pending log writes, 0 pending chkp writes 1002 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 137363456; in additional pool allocated 0 Dictionary memory allocated 412754 Buffer pool size 8191 Free buffers 7206 Database pages 984 Old database pages 343 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 160, created 824, written 1432 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 984, 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 0 read views open inside InnoDB Main thread process no. 1, id 139663316956928, state: sleeping Number of rows inserted 172, updated 189, deleted 45, read 536 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================