===================================== 111023 23:37:58 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 15 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5255, signal count 4845 Mutex spin waits 0, rounds 362238, OS waits 1191 RW-shared spins 7797, OS waits 3759; RW-excl spins 178, OS waits 47 ------------ TRANSACTIONS ------------ Trx id counter 0 1595880532 Purge done for trx's n:o < 0 1595879650 undo n:o < 0 0 History list length 30 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 19333, OS thread id 565387 MySQL thread id 1918, query id 7654430 localhost root SHOW ENGINE INNODB STATUS ---TRANSACTION 0 1595880531, not started, process no 19374, OS thread id 733364 MySQL thread id 741, query id 7654401 72.232.195.234 supreme ---TRANSACTION 0 1595833332, not started, process no 19261, OS thread id 270403 MySQL thread id 57, query id 7653444 72.232.228.242 of ---TRANSACTION 0 1595767986, not started, process no 19258, OS thread id 258112 MySQL thread id 54, query id 7654402 72.232.228.242 of ---TRANSACTION 0 1595847080, not started, process no 19255, OS thread id 245821 MySQL thread id 51, query id 7654382 72.232.228.242 of ---TRANSACTION 0 1595866800, not started, process no 19257, OS thread id 254015 MySQL thread id 53, query id 7654402 72.232.228.242 of ---TRANSACTION 0 1595826151, not started, process no 19263, OS thread id 278597 MySQL thread id 59, query id 7653444 72.232.228.242 of ---TRANSACTION 0 1595874074, not started, process no 19262, OS thread id 274500 MySQL thread id 58, query id 7653444 72.232.228.242 of ---TRANSACTION 0 1595874024, not started, process no 19260, OS thread id 266306 MySQL thread id 56, query id 7653443 72.232.228.242 of ---TRANSACTION 0 1595833610, not started, process no 19259, OS thread id 262209 MySQL thread id 55, query id 7654429 72.232.228.242 of ---TRANSACTION 0 1595818021, not started, process no 19256, OS thread id 249918 MySQL thread id 52, query id 7654382 72.232.228.242 of ---TRANSACTION 0 1595880225, not started, process no 19252, OS thread id 233530 MySQL thread id 48, query id 7652986 72.232.195.234 supreme ---TRANSACTION 0 1595880105, not started, process no 19249, OS thread id 221239 MySQL thread id 45, query id 7652737 72.232.195.234 supreme ---TRANSACTION 0 1595880344, not started, process no 19250, OS thread id 225336 MySQL thread id 46, query id 7654261 72.232.195.234 supreme ---TRANSACTION 0 1595880489, not started, process no 19248, OS thread id 217142 MySQL thread id 44, query id 7651303 72.232.195.234 supreme ---TRANSACTION 0 1595880230, not started, process no 19247, OS thread id 213045 MySQL thread id 43, query id 7653064 72.232.195.234 supreme ---TRANSACTION 0 1595880215, not started, process no 19246, OS thread id 208948 MySQL thread id 42, query id 7652980 72.232.195.234 supreme ---TRANSACTION 0 1595880360, not started, process no 19254, OS thread id 241724 MySQL thread id 50, query id 7653030 72.232.195.234 supreme ---TRANSACTION 0 1595880356, not started, process no 19245, OS thread id 204851 MySQL thread id 41, query id 7651894 72.232.195.234 supreme ---TRANSACTION 0 1595880270, not started, process no 19253, OS thread id 237627 MySQL thread id 49, query id 7653644 72.232.195.234 supreme ---TRANSACTION 0 1595880260, not started, process no 19251, OS thread id 229433 MySQL thread id 47, query id 7652972 72.232.195.234 supreme ---TRANSACTION 0 1595880403, not started, process no 19243, OS thread id 200754 MySQL thread id 40, query id 7652919 72.232.195.234 supreme ---TRANSACTION 0 1595880372, not started, process no 19242, OS thread id 196657 MySQL thread id 39, query id 7653977 72.232.195.234 supreme ---TRANSACTION 0 1595880379, not started, process no 19241, OS thread id 192560 MySQL thread id 38, query id 7654349 72.232.195.234 supreme ---TRANSACTION 0 1595880377, not started, process no 19224, OS thread id 122911 MySQL thread id 21, query id 7654305 72.232.195.234 supreme ---TRANSACTION 0 1595880527, not started, process no 19239, OS thread id 184366 MySQL thread id 36, query id 7653951 72.232.195.234 supreme ---TRANSACTION 0 1595879963, not started, process no 19240, OS thread id 188463 MySQL thread id 37, query id 7652948 72.232.195.234 supreme ---TRANSACTION 0 1595880125, not started, process no 19222, OS thread id 114717 MySQL thread id 19, query id 7653151 72.232.195.234 supreme ---TRANSACTION 0 1595880473, not started, process no 19238, OS thread id 180269 MySQL thread id 35, query id 7653361 72.232.195.234 supreme ---TRANSACTION 0 1595879454, not started, process no 19228, OS thread id 139299 MySQL thread id 25, query id 7653146 72.232.195.234 supreme ---TRANSACTION 0 1595880452, not started, process no 19223, OS thread id 118814 MySQL thread id 20, query id 7652756 72.232.195.234 supreme ---TRANSACTION 0 1595880264, not started, process no 19225, OS thread id 127008 MySQL thread id 22, query id 7653058 72.232.195.234 supreme ---TRANSACTION 0 1595880158, not started, process no 19208, OS thread id 57359 MySQL thread id 5, query id 7652914 72.232.195.234 supreme ---TRANSACTION 0 1595880249, not started, process no 19236, OS thread id 172075 MySQL thread id 33, query id 7654361 72.232.195.234 supreme ---TRANSACTION 0 1595880223, not started, process no 19206, OS thread id 49165 MySQL thread id 3, query id 7649726 72.232.195.234 supreme ---TRANSACTION 0 1595880188, not started, process no 19231, OS thread id 151590 MySQL thread id 28, query id 7652658 72.232.195.234 supreme ---TRANSACTION 0 1595880509, not started, process no 19214, OS thread id 81941 MySQL thread id 11, query id 7653520 72.232.195.234 supreme ---TRANSACTION 0 1595880434, not started, process no 19234, OS thread id 163881 MySQL thread id 31, query id 7652691 72.232.195.234 supreme ---TRANSACTION 0 1595880501, not started, process no 19216, OS thread id 90135 MySQL thread id 13, query id 7652875 72.232.195.234 supreme ---TRANSACTION 0 1595880183, not started, process no 19217, OS thread id 94232 MySQL thread id 14, query id 7654416 72.232.195.234 supreme ---TRANSACTION 0 1595880140, not started, process no 19218, OS thread id 98329 MySQL thread id 15, query id 7653639 72.232.195.234 supreme ---TRANSACTION 0 1595880254, not started, process no 19212, OS thread id 73747 MySQL thread id 9, query id 7651272 72.232.195.234 supreme ---TRANSACTION 0 1595880428, not started, process no 19237, OS thread id 176172 MySQL thread id 34, query id 7654400 72.232.195.234 supreme ---TRANSACTION 0 1595879804, not started, process no 19235, OS thread id 167978 MySQL thread id 32, query id 7651736 72.232.195.234 supreme ---TRANSACTION 0 1595879999, not started, process no 19210, OS thread id 65553 MySQL thread id 7, query id 7653559 72.232.195.234 supreme ---TRANSACTION 0 1595880485, not started, process no 19220, OS thread id 106523 MySQL thread id 17, query id 7654429 72.232.195.234 supreme ---TRANSACTION 0 1595880496, not started, process no 19211, OS thread id 69650 MySQL thread id 8, query id 7652752 72.232.195.234 supreme ---TRANSACTION 0 1595880178, not started, process no 19233, OS thread id 159784 MySQL thread id 30, query id 7653938 72.232.195.234 supreme ---TRANSACTION 0 1595880267, not started, process no 19213, OS thread id 77844 MySQL thread id 10, query id 7653495 72.232.195.234 supreme ---TRANSACTION 0 1595880227, not started, process no 19227, OS thread id 135202 MySQL thread id 24, query id 7653095 72.232.195.234 supreme ---TRANSACTION 0 1595880056, not started, process no 19219, OS thread id 102426 MySQL thread id 16, query id 7653113 72.232.195.234 supreme ---TRANSACTION 0 1595880321, not started, process no 19215, OS thread id 86038 MySQL thread id 12, query id 7652844 72.232.195.234 supreme ---TRANSACTION 0 1595880470, not started, process no 19209, OS thread id 61456 MySQL thread id 6, query id 7653246 72.232.195.234 supreme ---TRANSACTION 0 1595880015, not started, process no 19205, OS thread id 45068 MySQL thread id 2, query id 7654223 72.232.195.234 supreme ---TRANSACTION 0 1595880326, not started, process no 19221, OS thread id 110620 MySQL thread id 18, query id 7651810 72.232.195.234 supreme ---TRANSACTION 0 1595880437, not started, process no 19232, OS thread id 155687 MySQL thread id 29, query id 7651667 72.232.195.234 supreme ---TRANSACTION 0 1595880511, not started, process no 19226, OS thread id 131105 MySQL thread id 23, query id 7653649 72.232.195.234 supreme ---TRANSACTION 0 1595880337, not started, process no 19230, OS thread id 147493 MySQL thread id 27, query id 7654005 72.232.195.234 supreme ---TRANSACTION 0 1595880516, not started, process no 19204, OS thread id 40971 MySQL thread id 1, query id 7652760 72.232.195.234 supreme -------- 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 3130 OS file reads, 62457 OS file writes, 38371 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 inserts, 16 merged recs, 9 merges Hash table size 1106407, used cells 247138, node heap has 275 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 2 278129312 Log flushed up to 2 278129312 Last checkpoint at 2 278129312 0 pending log writes, 0 pending chkp writes 26646 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 313289658; in additional pool allocated 5353984 Buffer pool size 16384 Free buffers 4711 Database pages 11398 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 5993, created 5405, written 66972 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 19202, id 32777, state: sleeping Number of rows inserted 554047, updated 9445, deleted 5277, read 1310769557 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================