*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2020-02-17 21:39:43 0x25ac INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 52 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 28 srv_active, 0 srv_shutdown, 21486 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 49 OS WAIT ARRAY INFO: signal count 220 RW-shared spins 121, rounds 121, OS waits 0 RW-excl spins 1672, rounds 5763, OS waits 43 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 1.00 RW-shared, 3.45 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 8428 Purge done for trx's n:o < 8423 undo n:o < 0 state: running but idle History list length 892 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283126386471152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283126386468608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 8427, ACTIVE 50 sec 3 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 10, OS thread handle 16632, query id 210 localhost 127.0.0.1 root TABLE LOCK table `test`.`foo` trx id 8427 lock mode IX RECORD LOCKS space id 98 page no 4 n bits 72 index PRIMARY of table `test`.`foo` trx id 8427 lock_mode X Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 4; hex 80000001; asc ;; 1: len 6; hex 0000000020de; asc ;; 2: len 7; hex 81000000a70110; asc ;; 3: len 4; hex 80000001; asc ;; 4: len 1; hex 41; asc A;; RECORD LOCKS space id 98 page no 4 n bits 72 index PRIMARY of table `test`.`foo` trx id 8427 lock_mode X locks gap before rec Record lock, heap no 3 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 4; hex 80000003; asc ;; 1: len 6; hex 0000000020de; asc ;; 2: len 7; hex 81000000a7011d; asc ;; 3: len 4; hex 80000003; asc ;; 4: len 1; hex 42; asc B;; -------- 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] , 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 1628 OS file reads, 11769 OS file writes, 2872 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.08 writes/s, 0.06 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 69257, node heap has 3 buffer(s) Hash table size 69257, node heap has 2 buffer(s) Hash table size 69257, node heap has 2 buffer(s) Hash table size 69257, node heap has 14 buffer(s) Hash table size 69257, node heap has 17 buffer(s) Hash table size 69257, node heap has 16 buffer(s) Hash table size 69257, node heap has 6 buffer(s) Hash table size 69257, node heap has 7 buffer(s) 0.00 hash searches/s, 0.12 non-hash searches/s --- LOG --- Log sequence number 43788173 Log buffer assigned up to 43788173 Log buffer completed up to 43788173 Log written up to 43788173 Log flushed up to 43788173 Added dirty pages up to 43788173 Pages flushed up to 43788173 Last checkpoint at 43788173 8528 log i/o's done, 0.02 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 274726912 Dictionary memory allocated 501477 Buffer pool size 16384 Free buffers 13873 Database pages 2444 Old database pages 882 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2243, not young 79172 0.00 youngs/s, 0.00 non-youngs/s Pages read 1593, created 865, written 2789 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: 2444, unzip_LRU len: 0 I/O sum[1]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=14220, Main thread ID=0000000000002080 , state=sleeping Number of rows inserted 5, updated 0, deleted 1, read 118 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.50 reads/s Number of system rows inserted 24805, updated 9718, deleted 21602, read 102963 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================