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 04:28:11 0x6fffc32156c0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 62 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 8246 srv_active, 0 srv_shutdown, 7342 srv_idle
srv_master_thread log flush and writes: 15587
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 55761
OS WAIT ARRAY INFO: signal count 1351464
RW-shared spins 4094254, rounds 7837526, OS waits 19592
RW-excl spins 2176370, rounds 3040530, OS waits 2866
RW-sx spins 479209, rounds 1382385, OS waits 2923
Spin rounds per wait: 1.91 RW-shared, 1.40 RW-excl, 2.88 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 417394752
Purge done for trx's n:o < 417394752 undo n:o < 0 state: running but idle
History list length 6
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 404628429697408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---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, 1208344 OS file writes, 149145 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 20.66 writes/s, 8.18 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 85 buffer(s)
Hash table size 2212699, node heap has 610 buffer(s)
Hash table size 2212699, node heap has 58 buffer(s)
Hash table size 2212699, node heap has 173 buffer(s)
Hash table size 2212699, node heap has 57 buffer(s)
Hash table size 2212699, node heap has 87 buffer(s)
Hash table size 2212699, node heap has 87 buffer(s)
Hash table size 2212699, node heap has 88 buffer(s)
595.65 hash searches/s, 66.16 non-hash searches/s
---
LOG
---
Log sequence number 742844923801
Log flushed up to   742844913027
Pages flushed up to 742844841178
Last checkpoint at  742844809281
0 pending log flushes, 0 pending chkp writes
451390 log i/o's done, 5.27 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8623489024
Dictionary memory allocated 324520
Buffer pool size   513728
Free buffers       416459
Database pages     96024
Old database pages 35282
Modified db pages  118
Percent of dirty pages(LRU & free pages): 0.023
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2387, not young 0
0.02 youngs/s, 0.00 non-youngs/s
Pages read 83986, created 12038, written 700268
0.00 reads/s, 0.05 creates/s, 12.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: 96024, 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       52133
Database pages     11957
Old database pages 4393
Modified db pages  33
Percent of dirty pages(LRU & free pages): 0.051
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 193, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10505, created 1452, written 101361
0.00 reads/s, 0.00 creates/s, 3.61 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: 11957, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   64216
Free buffers       51713
Database pages     12305
Old database pages 4522
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 373, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10833, created 1472, written 83938
0.00 reads/s, 0.00 creates/s, 0.39 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: 12305, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   64216
Free buffers       52174
Database pages     11910
Old database pages 4376
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 445, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10450, created 1460, written 69403
0.00 reads/s, 0.00 creates/s, 0.39 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: 11910, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   64216
Free buffers       51906
Database pages     12124
Old database pages 4455
Modified db pages  38
Percent of dirty pages(LRU & free pages): 0.059
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 191, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10547, created 1577, written 102220
0.00 reads/s, 0.00 creates/s, 2.39 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: 12124, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   64216
Free buffers       52105
Database pages     11990
Old database pages 4405
Modified db pages  32
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 174, not young 0
0.02 youngs/s, 0.00 non-youngs/s
Pages read 10625, created 1365, written 89608
0.00 reads/s, 0.00 creates/s, 2.23 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: 11990, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   64216
Free buffers       52137
Database pages     11904
Old database pages 4374
Modified db pages  9
Percent of dirty pages(LRU & free pages): 0.014
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 427, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10217, created 1687, written 85044
0.00 reads/s, 0.02 creates/s, 1.39 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: 11904, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   64216
Free buffers       52254
Database pages     11828
Old database pages 4346
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.008
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 10427, created 1401, written 86713
0.00 reads/s, 0.00 creates/s, 1.54 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: 11828, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   64216
Free buffers       52037
Database pages     12006
Old database pages 4411
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 310, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10382, created 1624, written 81981
0.00 reads/s, 0.04 creates/s, 0.89 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: 12006, 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 307614, updated 20115610, deleted 0, read 3382891205
0.45 inserts/s, 3.34 updates/s, 0.00 deletes/s, 203368.32 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 4322
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================