Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =====================================
- 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
- ============================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement