Type Name Status InnoDB ===================================== 2023-09-25 13:56:04 140374566708992 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 33 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 23114 srv_active, 0 srv_shutdown, 984477 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2406913 OS WAIT ARRAY INFO: signal count 4908344 RW-shared spins 0, rounds 0, OS waits 0 RW-excl spins 0, rounds 0, OS waits 0 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 11848324 Purge done for trx's n:o < 11848324 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421850019028992, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421850019028184, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421850019027376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421850019026568, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- 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] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 18446744073709551593 465706 OS file reads, 18700985 OS file writes, 8192840 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 42753, seg size 42755, 54008 merges merged operations: insert 27186, delete mark 38626239, delete 122830 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 11953103, node heap has 163 buffer(s) Hash table size 11953103, node heap has 1271 buffer(s) Hash table size 11953103, node heap has 2811 buffer(s) Hash table size 11953103, node heap has 3865 buffer(s) Hash table size 11953103, node heap has 16909 buffer(s) Hash table size 11953103, node heap has 17591 buffer(s) Hash table size 11953103, node heap has 18620 buffer(s) Hash table size 11953103, node heap has 274 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 1116288626820 Log buffer assigned up to 1116288626820 Log buffer completed up to 1116288626820 Log written up to 1116288626820 Log flushed up to 1116288626820 Added dirty pages up to 1116288626820 Pages flushed up to 1116288626820 Last checkpoint at 1116288626820 13800790 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 0 Dictionary memory allocated 5191804 Buffer pool size 311040 Free buffers 215933 Database pages 93411 Old database pages 34503 Modified db pages 32 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 93541, created 74, written 23184 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: 93411, unzip_LRU len: 0 I/O sum[2057]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 0 out of 1000 descriptors used Main thread process no. 98687, id 140374090751744, state: flushing log Number of rows inserted 22044, updated 6789402, deleted 1115, read 8790853 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT
