2. MariaDB [(none)]> SHOW ENGINE INNODB STATUS; | Type | Name | Status | InnoDB | ===================================== 2026-10-15 10:50:54 0x7f06d9910700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 7 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 4 srv_active, 0 srv_shutdown, 74121 srv_idle srv_master_thread log flush and writes: 74125 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 170052016 Purge done for trx's n:o < 170052016 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x55a3c9956f40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9956440), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9954e40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c995b140), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9954340), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9953840), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9952d40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9952240), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9951740), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9950c40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9950140), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c994f640), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c994eb40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync): 0 40510 OS file reads, 41917 OS file writes, 89675 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 1.14 fsyncs/s --- LOG --- Log sequence number 584350454959 Log flushed up to 584350454893 Pages flushed up to 584332860059 Last checkpoint at 584332860059 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8724152320 Dictionary memory allocated 53630808 Buffer pool size 519168 Free buffers 458278 Database pages 60890 Old database pages 22473 Modified db pages 1045 Percent of dirty pages(LRU & free pages): 0.201 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 16106, not young 6876024 0.00 youngs/s, 0.00 non-youngs/s Pages read 40047, created 35339, written 41779 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: 60890, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.001 sec) MariaDB [(none)]> SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2026-10-15 10:51:00 0x7f06d9910700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 3 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 4 srv_active, 0 srv_shutdown, 74127 srv_idle srv_master_thread log flush and writes: 74131 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 170052020 Purge done for trx's n:o < 170052020 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x55a3c9956f40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9956440), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9954e40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c995b140), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9954340), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9953840), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9952d40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9952240), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9951740), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9950c40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c9950140), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c994f640), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x55a3c994eb40), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync): 0 40510 OS file reads, 41917 OS file writes, 89681 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 1.33 fsyncs/s --- LOG --- Log sequence number 584350455929 Log flushed up to 584350455929 Pages flushed up to 584332860059 Last checkpoint at 584332860059 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8724152320 Dictionary memory allocated 53630808 Buffer pool size 519168 Free buffers 458278 Database pages 60890 Old database pages 22473 Modified db pages 1045 Percent of dirty pages(LRU & free pages): 0.201 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 16106, not young 6876024 0.00 youngs/s, 0.00 non-youngs/s Pages read 40047, created 35339, written 41779 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: 60890, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================