| InnoDB | | ===================================== 2025-05-09 12:59:40 0x7f6b900b8640 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 34 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1549 srv_idle srv_master_thread log flush and writes: 31 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 4076878791 Purge done for trx's n:o < 4076878699 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: -------- FILE I/O -------- Pending flushes (fsync): 0 117438 OS file reads, 12523 OS file writes, 287 OS fsyncs 248.88 reads/s, 52974 avg bytes/read, 104.35 writes/s, 0.53 fsyncs/s --- LOG --- Log sequence number 48942623814362 Log flushed up to 48942623787474 Pages flushed up to 48942623786454 Last checkpoint at 48942623786454 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4563402752 Dictionary memory allocated 1280472 Buffer pool size 65024 Free buffers 1005 Database pages 64019 Old database pages 23637 Modified db pages 167 Percent of dirty pages(LRU & free pages): 0.257 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 57447, not young 8567999 1.18 youngs/s, 19175.94 non-youngs/s Pages read 116371, created 9010, written 12523 248.88 reads/s, 2.06 creates/s, 104.35 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 67 / 1000 Pages read ahead 47.68/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64019, unzip_LRU len: 0 I/O sum[36624]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================