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 21:20:14 0x6fffc32f66c0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 59 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 50483 srv_active, 0 srv_shutdown, 25582 srv_idle
srv_master_thread log flush and writes: 76064
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 207948
OS WAIT ARRAY INFO: signal count 2852695
RW-shared spins 8731963, rounds 17410812, OS waits 60064
RW-excl spins 4386172, rounds 6319194, OS waits 7511
RW-sx spins 927471, rounds 2763459, OS waits 6165
Spin rounds per wait: 1.99 RW-shared, 1.44 RW-excl, 2.98 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 419756620
Purge done for trx's n:o < 419756620 undo n:o < 0 state: running but idle
History list length 1
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: 1; buffer pool: 0
84122 OS file reads, 3815448 OS file writes, 792007 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 11.63 writes/s, 8.20 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 306 buffer(s)
Hash table size 2212699, node heap has 892 buffer(s)
Hash table size 2212699, node heap has 312 buffer(s)
Hash table size 2212699, node heap has 510 buffer(s)
Hash table size 2212699, node heap has 261 buffer(s)
Hash table size 2212699, node heap has 305 buffer(s)
Hash table size 2212699, node heap has 329 buffer(s)
Hash table size 2212699, node heap has 307 buffer(s)
268.55 hash searches/s, 36.61 non-hash searches/s
---
LOG
---
Log sequence number 754442022110
Log flushed up to   754442022056
Pages flushed up to 754442022110
Last checkpoint at  754442020836
1 pending log flushes, 0 pending chkp writes
1533803 log i/o's done, 2.29 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8623489024
Dictionary memory allocated 324520
Buffer pool size   513728
Free buffers       397164
Database pages     113342
Old database pages 41676
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 2866, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 83986, created 29356, written 1989850
0.00 reads/s, 0.00 creates/s, 6.44 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: 113342, 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       49906
Database pages     13938
Old database pages 5125
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 271, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10505, created 3433, written 320356
0.00 reads/s, 0.00 creates/s, 1.46 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: 13938, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   64216
Free buffers       49244
Database pages     14516
Old database pages 5338
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 405, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10833, created 3683, written 199340
0.00 reads/s, 0.00 creates/s, 0.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: 14516, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   64216
Free buffers       50009
Database pages     13812
Old database pages 5078
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 522, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10450, created 3362, written 178710
0.00 reads/s, 0.00 creates/s, 0.34 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: 13812, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   64216
Free buffers       49492
Database pages     14311
Old database pages 5262
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 252, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10547, created 3764, written 294689
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: 14311, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   64216
Free buffers       49804
Database pages     14042
Old database pages 5163
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 246, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10625, created 3417, written 276471
0.00 reads/s, 0.00 creates/s, 0.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: 14042, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   64216
Free buffers       49541
Database pages     14258
Old database pages 5243
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 514, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10217, created 4041, written 230746
0.00 reads/s, 0.00 creates/s, 0.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: 14258, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   64216
Free buffers       49849
Database pages     13977
Old database pages 5139
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 313, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10427, created 3550, written 238443
0.00 reads/s, 0.00 creates/s, 0.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: 13977, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   64216
Free buffers       49319
Database pages     14488
Old database pages 5328
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 343, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10382, created 4106, written 251095
0.00 reads/s, 0.00 creates/s, 1.07 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: 14488, 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: making checkpoint
Number of rows inserted 1464289, updated 43489313, deleted 0, read 23245567581
0.47 inserts/s, 0.22 updates/s, 0.00 deletes/s, 215907.95 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 9464
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================