MariaDB [(none)]> SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2024-02-22 15:36:48 0x7f3ae0047700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 7 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 0 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2000112 OS WAIT ARRAY INFO: signal count 1796567 RW-shared spins 907926, rounds 16219224, OS waits 344177 RW-excl spins 377658, rounds 4205057, OS waits 99606 RW-sx spins 1435, rounds 40907, OS waits 1322 Spin rounds per wait: 17.86 RW-shared, 11.13 RW-excl, 28.51 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 12162048051 Purge done for trx's n:o < 0 undo n:o < 0 state: disabled History list length 323384015 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421365853835768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421365853831592, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421365853827416, not started flushing log 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421365853823240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 11502141778, ACTIVE 863007 sec recovered trx 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 ---TRANSACTION 11544330019, ACTIVE 863007 sec recovered trx 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 -------- 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: complete io for buf page (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: 1; buffer pool: 1 55564404 OS file reads, 215860723 OS file writes, 177126590 OS fsyncs 4.71 reads/s, 16384 avg bytes/read, 378.23 writes/s, 352.81 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 81587, free list len 41306, seg size 122894, 882870 merges merged operations: insert 5230577, delete mark 8711266, delete 0 discarded operations: insert 90323, delete mark 3745447, delete 0 Hash table size 1328213, node heap has 104 buffer(s) Hash table size 1328213, node heap has 172 buffer(s) Hash table size 1328213, node heap has 109 buffer(s) Hash table size 1328213, node heap has 207 buffer(s) Hash table size 1328213, node heap has 69 buffer(s) Hash table size 1328213, node heap has 839 buffer(s) Hash table size 1328213, node heap has 1998 buffer(s) Hash table size 1328213, node heap has 116 buffer(s) 1105.56 hash searches/s, 1009.28 non-hash searches/s --- LOG --- Log sequence number 62280646364492 Log flushed up to 62280646363951 Pages flushed up to 62280599796728 Last checkpoint at 62280413685495 1 pending log flushes, 0 pending chkp writes 134430978 log i/o's done, 295.43 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 5514985472 Dictionary memory allocated 21222432 Buffer pool size 327680 Free buffers 8190 Database pages 315876 Old database pages 116443 Modified db pages 7733 Percent of dirty pages(LRU & free pages): 2.386 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 7, single page 0 Pages made young 16211407, not young 314067350 2.00 youngs/s, 6.71 non-youngs/s Pages read 55555773, created 22452108, written 66422525 5.28 reads/s, 24.43 creates/s, 62.13 writes/s Buffer pool hit rate 999 / 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: 315876, unzip_LRU len: 0 I/O sum[42432]:cur[463], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 40960 Free buffers 1024 Database pages 39495 Old database pages 14559 Modified db pages 1009 Percent of dirty pages(LRU & free pages): 2.490 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 2054803, not young 38448730 0.14 youngs/s, 0.43 non-youngs/s Pages read 7091275, created 2792683, written 8177575 0.43 reads/s, 1.57 creates/s, 7.71 writes/s Buffer pool hit rate 999 / 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: 39495, unzip_LRU len: 0 I/O sum[5304]:cur[56], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 40960 Free buffers 1024 Database pages 39496 Old database pages 14559 Modified db pages 1052 Percent of dirty pages(LRU & free pages): 2.596 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2034225, not young 41578452 0.29 youngs/s, 1.14 non-youngs/s Pages read 6969627, created 2808433, written 7699360 0.86 reads/s, 7.86 creates/s, 7.86 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39496, unzip_LRU len: 0 I/O sum[5304]:cur[56], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 40960 Free buffers 1024 Database pages 39491 Old database pages 14557 Modified db pages 800 Percent of dirty pages(LRU & free pages): 1.975 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2009613, not young 38404952 0.14 youngs/s, 0.43 non-youngs/s Pages read 6971242, created 2805693, written 7910287 0.43 reads/s, 4.14 creates/s, 7.86 writes/s Buffer pool hit rate 999 / 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: 39491, unzip_LRU len: 0 I/O sum[5304]:cur[56], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 40960 Free buffers 1024 Database pages 39483 Old database pages 14554 Modified db pages 936 Percent of dirty pages(LRU & free pages): 2.311 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2042180, not young 39247543 0.14 youngs/s, 0.57 non-youngs/s Pages read 6986319, created 2808824, written 8900130 0.86 reads/s, 6.00 creates/s, 7.86 writes/s Buffer pool hit rate 998 / 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: 39483, unzip_LRU len: 0 I/O sum[5304]:cur[56], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 40960 Free buffers 1024 Database pages 39486 Old database pages 14555 Modified db pages 989 Percent of dirty pages(LRU & free pages): 2.441 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 2043264, not young 40681368 0.43 youngs/s, 0.86 non-youngs/s Pages read 6993155, created 2806976, written 9418330 0.86 reads/s, 1.29 creates/s, 7.57 writes/s Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39486, unzip_LRU len: 0 I/O sum[5304]:cur[56], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 40960 Free buffers 1025 Database pages 39478 Old database pages 14554 Modified db pages 849 Percent of dirty pages(LRU & free pages): 2.096 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2021440, not young 38217039 0.43 youngs/s, 0.57 non-youngs/s Pages read 6838859, created 2809437, written 7938147 0.29 reads/s, 1.00 creates/s, 8.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39478, unzip_LRU len: 0 I/O sum[5304]:cur[61], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 40960 Free buffers 1021 Database pages 39474 Old database pages 14554 Modified db pages 1128 Percent of dirty pages(LRU & free pages): 2.785 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 1, single page 0 Pages made young 1993089, not young 38532155 0.00 youngs/s, 2.29 non-youngs/s Pages read 6950034, created 2808989, written 8514351 1.14 reads/s, 0.71 creates/s, 7.71 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 4 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39474, unzip_LRU len: 0 I/O sum[5304]:cur[61], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 40960 Free buffers 1024 Database pages 39473 Old database pages 14551 Modified db pages 970 Percent of dirty pages(LRU & free pages): 2.395 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 2012793, not young 38957111 0.43 youngs/s, 0.43 non-youngs/s Pages read 6755262, created 2811073, written 7864345 0.43 reads/s, 1.86 creates/s, 7.57 writes/s Buffer pool hit rate 999 / 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: 39473, unzip_LRU len: 0 I/O sum[5304]:cur[61], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=0, Main thread ID=0, state: Number of rows inserted 162881775, updated 16854388, deleted 159473924, read 1737374214 275.25 inserts/s, 9.43 updates/s, 281.53 deletes/s, 293.39 reads/s Number of system rows inserted 134313832, updated 0, deleted 134313832, read 134313836 295.53 inserts/s, 0.00 updates/s, 295.53 deletes/s, 295.53 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.003 sec)