Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
===================================== 2026-07-22 08:43:33 0x36dc INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 42 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 82875 srv_active, 0 srv_shutdown, 667 srv_idle srv_master_thread log flush and writes: 83539 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 912267 OS WAIT ARRAY INFO: signal count 2085570 RW-shared spins 2286281, rounds 14911125, OS waits 352311 RW-excl spins 3837010, rounds 17830930, OS waits 338080 RW-sx spins 567602, rounds 3808200, OS waits 54416 Spin rounds per wait: 6.52 RW-shared, 4.65 RW-excl, 6.71 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 936447202 Purge done for trx's n:o < 936447202 undo n:o < 0 state: running but idle History list length 10 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283506092298456, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283506092294288, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (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: 0; buffer pool: 0 756878 OS file reads, 48656497 OS file writes, 20584700 OS fsyncs 0.07 reads/s, 16384 avg bytes/read, 193.57 writes/s, 40.71 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 405, seg size 407, 3129 merges merged operations: insert 1299, delete mark 2210, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553253, node heap has 143 buffer(s) Hash table size 553253, node heap has 129 buffer(s) Hash table size 553253, node heap has 51 buffer(s) Hash table size 553253, node heap has 9 buffer(s) Hash table size 553253, node heap has 54 buffer(s) Hash table size 553253, node heap has 99 buffer(s) Hash table size 553253, node heap has 439 buffer(s) Hash table size 553253, node heap has 7 buffer(s) 1868.88 hash searches/s, 4600.03 non-hash searches/s --- LOG --- Log sequence number 902484771700 Log flushed up to 902484771466 Pages flushed up to 902484013030 Last checkpoint at 902483591193 0 pending log flushes, 0 pending chkp writes 16861270 log i/o's done, 4.21 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2281701376 Dictionary memory allocated 227864 Buffer pool size 128432 Free buffers 8210 Database pages 119291 Old database pages 43872 Modified db pages 635 Percent of dirty pages(LRU & free pages): 0.498 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1322004, not young 97367354 0.12 youngs/s, 0.17 non-youngs/s Pages read 756784, created 564652, written 30143283 0.07 reads/s, 0.02 creates/s, 172.52 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: 119291, unzip_LRU len: 0 I/O sum[68728]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16054 Free buffers 1025 Database pages 14929 Old database pages 5490 Modified db pages 116 Percent of dirty pages(LRU & free pages): 0.727 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 180848, not young 12347838 0.00 youngs/s, 0.00 non-youngs/s Pages read 94715, created 71517, written 3890515 0.00 reads/s, 0.00 creates/s, 24.74 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: 14929, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16054 Free buffers 1029 Database pages 14904 Old database pages 5481 Modified db pages 58 Percent of dirty pages(LRU & free pages): 0.364 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 118718, not young 12178487 0.00 youngs/s, 0.00 non-youngs/s Pages read 91351, created 70255, written 3014007 0.00 reads/s, 0.00 creates/s, 19.62 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: 14904, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16054 Free buffers 1026 Database pages 14914 Old database pages 5485 Modified db pages 142 Percent of dirty pages(LRU & free pages): 0.891 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 230181, not young 12080752 0.00 youngs/s, 0.05 non-youngs/s Pages read 95383, created 70619, written 4229199 0.02 reads/s, 0.00 creates/s, 27.64 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: 14914, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16054 Free buffers 1030 Database pages 14910 Old database pages 5483 Modified db pages 63 Percent of dirty pages(LRU & free pages): 0.395 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 132360, not young 12156104 0.00 youngs/s, 0.00 non-youngs/s Pages read 94597, created 69720, written 4551825 0.00 reads/s, 0.00 creates/s, 21.36 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: 14910, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16054 Free buffers 1024 Database pages 14899 Old database pages 5480 Modified db pages 64 Percent of dirty pages(LRU & free pages): 0.402 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 175831, not young 12328016 0.00 youngs/s, 0.12 non-youngs/s Pages read 94894, created 69143, written 4034753 0.05 reads/s, 0.00 creates/s, 21.07 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: 14899, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16054 Free buffers 1024 Database pages 14908 Old database pages 5483 Modified db pages 94 Percent of dirty pages(LRU & free pages): 0.590 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 164335, not young 12331098 0.12 youngs/s, 0.00 non-youngs/s Pages read 96685, created 72041, written 3710788 0.00 reads/s, 0.02 creates/s, 22.90 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: 14908, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16054 Free buffers 1025 Database pages 14909 Old database pages 5484 Modified db pages 68 Percent of dirty pages(LRU & free pages): 0.427 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 139450, not young 11619909 0.00 youngs/s, 0.00 non-youngs/s Pages read 93071, created 70042, written 3371314 0.00 reads/s, 0.00 creates/s, 18.88 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: 14909, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16054 Free buffers 1027 Database pages 14918 Old database pages 5486 Modified db pages 30 Percent of dirty pages(LRU & free pages): 0.188 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 180281, not young 12325150 0.00 youngs/s, 0.00 non-youngs/s Pages read 96088, created 71315, written 3340882 0.00 reads/s, 0.00 creates/s, 16.31 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: 14918, unzip_LRU len: 0 I/O sum[8591]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=4272, Main thread ID=5704, state: sleeping Number of rows inserted 14520, updated 13852426, deleted 1795, read 305669089 0.02 inserts/s, 75.09 updates/s, 0.00 deletes/s, 332.87 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 113962 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================