Motores de almacenamiento

InnoDB

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

[ Variables | Reserva de búfers | Estado del InnoDB ]

=====================================
2025-12-16 13:10:47 0x6fffc309e6c0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 63 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 32030 srv_active, 0 srv_shutdown, 14801 srv_idle
srv_master_thread log flush and writes: 46830
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 134882
OS WAIT ARRAY INFO: signal count 1502279
RW-shared spins 4556723, rounds 8770639, OS waits 30271
RW-excl spins 2343720, rounds 3334170, OS waits 3186
RW-sx spins 479628, rounds 1385999, OS waits 2934
Spin rounds per wait: 1.92 RW-shared, 1.42 RW-excl, 2.89 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 418369621
Purge done for trx's n:o < 418369621 undo n:o < 0 state: running
History list length 4
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 404628429693192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 404628429688976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (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
84122 OS file reads, 2183463 OS file writes, 479727 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 20.57 writes/s, 12.33 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 31, seg size 33, 47 merges
merged operations:
 insert 47, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 2212699, node heap has 196 buffer(s)
Hash table size 2212699, node heap has 677 buffer(s)
Hash table size 2212699, node heap has 204 buffer(s)
Hash table size 2212699, node heap has 298 buffer(s)
Hash table size 2212699, node heap has 152 buffer(s)
Hash table size 2212699, node heap has 212 buffer(s)
Hash table size 2212699, node heap has 216 buffer(s)
Hash table size 2212699, node heap has 198 buffer(s)
585.48 hash searches/s, 18.00 non-hash searches/s
---
LOG
---
Log sequence number 744162148089
Log flushed up to   744162148089
Pages flushed up to 744162148089
Last checkpoint at  744162139908
0 pending log flushes, 0 pending chkp writes
902374 log i/o's done, 2.65 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8623489024
Dictionary memory allocated 324520
Buffer pool size   513728
Free buffers       407682
Database pages     103893
Old database pages 38186
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2584, not young 0
0.03 youngs/s, 0.00 non-youngs/s
Pages read 83986, created 19907, written 1106133
0.00 reads/s, 0.00 creates/s, 13.21 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: 103893, 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   64216
Free buffers       51094
Database pages     12881
Old database pages 4734
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 226, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10505, created 2376, written 182122
0.00 reads/s, 0.00 creates/s, 1.97 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: 12881, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   64216
Free buffers       50721
Database pages     13192
Old database pages 4849
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 386, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10833, created 2359, written 109320
0.00 reads/s, 0.00 creates/s, 0.97 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: 13192, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   64216
Free buffers       51154
Database pages     12801
Old database pages 4705
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 475, not young 0
0.02 youngs/s, 0.00 non-youngs/s
Pages read 10450, created 2351, written 95702
0.00 reads/s, 0.00 creates/s, 1.75 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: 12801, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   64216
Free buffers       50865
Database pages     13051
Old database pages 4797
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 216, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10547, created 2504, written 166766
0.00 reads/s, 0.00 creates/s, 2.27 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: 13051, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   64216
Free buffers       50990
Database pages     12978
Old database pages 4770
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 208, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10625, created 2353, written 155315
0.00 reads/s, 0.00 creates/s, 1.95 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: 12978, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   64216
Free buffers       50958
Database pages     12977
Old database pages 4770
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 463, not young 0
0.02 youngs/s, 0.00 non-youngs/s
Pages read 10217, created 2760, written 128477
0.00 reads/s, 0.00 creates/s, 0.73 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: 12977, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   64216
Free buffers       51106
Database pages     12873
Old database pages 4731
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 287, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10427, created 2446, written 135370
0.00 reads/s, 0.00 creates/s, 1.56 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: 12873, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   64216
Free buffers       50794
Database pages     13140
Old database pages 4830
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 323, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10382, created 2758, written 133061
0.00 reads/s, 0.00 creates/s, 2.02 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: 13140, 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=3548, Main thread ID=123144354371264, state: sleeping
Number of rows inserted 909713, updated 22662420, deleted 0, read 14115522959
1.03 inserts/s, 0.19 updates/s, 0.00 deletes/s, 442985.16 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 8378
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================