Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
===================================== 2026-11-21 07:01:27 0x65c8 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 49 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 233122 srv_active, 0 srv_shutdown, 642035 srv_idle srv_master_thread log flush and writes: 875157 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3560158 OS WAIT ARRAY INFO: signal count 1741564 RW-shared spins 0, rounds 1756612, OS waits 694525 RW-excl spins 0, rounds 5979610, OS waits 9132 RW-sx spins 77839, rounds 616096, OS waits 2870 Spin rounds per wait: 1756612.00 RW-shared, 5979610.00 RW-excl, 7.92 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 37141800 Purge done for trx's n:o < 37141800 undo n:o < 0 state: running History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283026422892248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422883816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422888032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422871168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422879600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422875384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422866952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422862736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422858520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422854304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422845872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422841656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422837440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 283026422850088, not started 0 lock struct(s), heap size 1136, 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 11106 OS file reads, 22631392 OS file writes, 11253146 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 22.31 writes/s, 11.59 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 110, seg size 112, 1103 merges merged operations: insert 1411, delete mark 454, delete 444 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553253, node heap has 3 buffer(s) Hash table size 553253, node heap has 10 buffer(s) Hash table size 553253, node heap has 3 buffer(s) Hash table size 553253, node heap has 59 buffer(s) Hash table size 553253, node heap has 9 buffer(s) Hash table size 553253, node heap has 2 buffer(s) Hash table size 553253, node heap has 2 buffer(s) Hash table size 553253, node heap has 2 buffer(s) 7.92 hash searches/s, 18.39 non-hash searches/s --- LOG --- Log sequence number 95428784831 Log flushed up to 95428784584 Pages flushed up to 95428770561 Last checkpoint at 95428770139 0 pending log flushes, 0 pending chkp writes 3599901 log i/o's done, 3.82 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2181038080 Dictionary memory allocated 935712 Buffer pool size 128304 Free buffers 96622 Database pages 31592 Old database pages 11725 Modified db pages 108 Percent of dirty pages(LRU & free pages): 0.084 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1442, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 10681, created 20911, written 16582456 0.00 reads/s, 0.00 creates/s, 15.63 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: 31592, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16038 Free buffers 11450 Database pages 4577 Old database pages 1669 Modified db pages 15 Percent of dirty pages(LRU & free pages): 0.094 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 114, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1720, created 2857, written 2517918 0.00 reads/s, 0.00 creates/s, 2.76 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: 4577, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16038 Free buffers 12078 Database pages 3952 Old database pages 1457 Modified db pages 8 Percent of dirty pages(LRU & free pages): 0.050 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 393, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1367, created 2585, written 1267516 0.00 reads/s, 0.00 creates/s, 1.51 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: 3952, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16038 Free buffers 12385 Database pages 3636 Old database pages 1362 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.006 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 126, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1143, created 2493, written 1215926 0.00 reads/s, 0.00 creates/s, 1.16 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: 3636, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16038 Free buffers 11989 Database pages 4042 Old database pages 1511 Modified db pages 42 Percent of dirty pages(LRU & free pages): 0.262 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 115, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1353, created 2689, written 2902899 0.00 reads/s, 0.00 creates/s, 2.47 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: 4042, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16038 Free buffers 12087 Database pages 3935 Old database pages 1471 Modified db pages 2 Percent of dirty pages(LRU & free pages): 0.012 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 190, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1363, created 2572, written 2417934 0.00 reads/s, 0.00 creates/s, 2.35 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: 3935, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16038 Free buffers 12382 Database pages 3646 Old database pages 1365 Modified db pages 5 Percent of dirty pages(LRU & free pages): 0.031 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 76, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1188, created 2458, written 1771453 0.00 reads/s, 0.00 creates/s, 0.82 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: 3646, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16038 Free buffers 12239 Database pages 3790 Old database pages 1416 Modified db pages 21 Percent of dirty pages(LRU & free pages): 0.131 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 154, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1169, created 2621, written 2464570 0.00 reads/s, 0.00 creates/s, 2.37 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: 3790, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16038 Free buffers 12012 Database pages 4014 Old database pages 1474 Modified db pages 14 Percent of dirty pages(LRU & free pages): 0.087 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 274, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1378, created 2636, written 2024240 0.00 reads/s, 0.00 creates/s, 2.20 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: 4014, unzip_LRU len: 0 I/O sum[0]: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=24536, Main thread ID=26084, state: sleeping Number of rows inserted 1273416, updated 817170, deleted 694332, read 42923746 1.18 inserts/s, 0.86 updates/s, 0.27 deletes/s, 6.82 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 75488 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================