| InnoDB | | ===================================== 2025-05-09 12:56:05 0x7f6b900fa640 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 26 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1334 srv_idle srv_master_thread log flush and writes: 27 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 4076856926 Purge done for trx's n:o < 4076856925 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7f6b9c2e6b80), ACTIVE 28 sec starting index read mysql tables in use 6, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 1136, OS thread handle 140099827344960, query id 797653 localhost mct_dev Sending data SELECT Trx read view will not see trx with id >= 4076856923, sees < 4076856923 -------- FILE I/O -------- Pending flushes (fsync): 0 65025 OS file reads, 63 OS file writes, 41 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s --- LOG --- Log sequence number 48942065627083 Log flushed up to 48942065616327 Pages flushed up to 48942007744252 Last checkpoint at 48942007744252 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4563402752 Dictionary memory allocated 1275960 Buffer pool size 65024 Free buffers 2162 Database pages 62862 Old database pages 23184 Modified db pages 1661 Percent of dirty pages(LRU & free pages): 2.554 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 46347, not young 2766428 190.72 youngs/s, 0.00 non-youngs/s Pages read 63962, created 751, written 63 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: 62862, unzip_LRU len: 0 I/O sum[67]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================