Механізми зберігання

InnoDB

Supports transactions, row-level locking, foreign keys and encryption for tables

[ Змінні | Буферний пул | Статус InnoDB ]

=====================================
2025-12-14 12:41:23 0x7f70928fa700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 64 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 490 srv_active, 0 srv_shutdown, 984 srv_idle
srv_master_thread log flush and writes: 1474
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1945
OS WAIT ARRAY INFO: signal count 1580
RW-shared spins 0, rounds 916, OS waits 454
RW-excl spins 0, rounds 300, OS waits 10
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 916.00 RW-shared, 300.00 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 39134
Purge done for trx's n:o < 39134 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421596675863032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421596675858776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421596675854520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
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: waiting for completed aio requests (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: 0; buffer pool: 0
815 OS file reads, 6154 OS file writes, 3387 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.75 writes/s, 1.33 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 69257, node heap has 0 buffer(s)
Hash table size 69257, node heap has 8 buffer(s)
Hash table size 69257, node heap has 2 buffer(s)
Hash table size 69257, node heap has 25 buffer(s)
Hash table size 69257, node heap has 0 buffer(s)
Hash table size 69257, node heap has 3 buffer(s)
Hash table size 69257, node heap has 25 buffer(s)
Hash table size 69257, node heap has 0 buffer(s)
1.09 hash searches/s, 0.05 non-hash searches/s
---
LOG
---
Log sequence number 10297160
Log flushed up to   10296083
Pages flushed up to 10296083
Last checkpoint at  10296074
0 pending log flushes, 0 pending chkp writes
2223 log i/o's done, 0.91 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 285212672
Dictionary memory allocated 128256
Buffer pool size   16024
Free buffers       15174
Database pages     787
Old database pages 310
Modified db pages  50
Percent of dirty pages(LRU & free pages): 0.313
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 656, created 131, written 3538
0.00 reads/s, 0.00 creates/s, 0.70 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: 787, 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=905, Main thread ID=140120917255936, state: sleeping
Number of rows inserted 1, updated 814, deleted 0, read 447548
0.00 inserts/s, 0.28 updates/s, 0.00 deletes/s, 0.56 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 300
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================