| InnoDB | | ===================================== 2025-05-09 12:50:52 0x7f6b887d8640 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 60 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1021 srv_idle srv_master_thread log flush and writes: 21 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 4076856682 Purge done for trx's n:o < 4076854949 undo n:o < 0 state: running History list length 705 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 4076856681, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 82 MariaDB thread id 782, OS thread handle 140099955172928, query id 774321 localhost mct_dev Update INSERT INTO ---TRANSACTION (0x7f6b9c2e6b80), ACTIVE 229 sec starting index read mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 677, OS thread handle 140099954902592, query id 746622 localhost mct_dev Sending data SELECT Trx read view will not see trx with id >= 4076854949, sees < 4076854947 -------- FILE I/O -------- Pending flushes (fsync): 0 64242 OS file reads, 45 OS file writes, 27 OS fsyncs 0.23 reads/s, 65536 avg bytes/read, 0.00 writes/s, 0.02 fsyncs/s ------------------- ADAPTIVE HASH INDEX ------------------- Hash table size 149, node heap has 336 buffer(s) Hash table size 149, node heap has 29 buffer(s) Hash table size 149, node heap has 99 buffer(s) Hash table size 149, node heap has 43 buffer(s) Hash table size 149, node heap has 44 buffer(s) Hash table size 149, node heap has 53 buffer(s) Hash table size 149, node heap has 49 buffer(s) Hash table size 149, node heap has 59 buffer(s) 1609.92 hash searches/s, 1124.50 non-hash searches/s --- LOG --- Log sequence number 48942055296385 Log flushed up to 48942053650737 Pages flushed up to 48942007744252 Last checkpoint at 48942007744252 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4563402752 Dictionary memory allocated 1199256 Buffer pool size 65024 Free buffers 1417 Database pages 62911 Old database pages 23203 Modified db pages 1630 Percent of dirty pages(LRU & free pages): 2.534 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 39848, not young 2488176 6.02 youngs/s, 5.64 non-youngs/s Pages read 63247, created 748, written 45 0.23 reads/s, 1.05 creates/s, 0.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 62911, unzip_LRU len: 0 I/O sum[17]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================