=====================================
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
============================