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:49:18 0x7001e40d26c0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 34 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 9005 srv_active, 0 srv_shutdown, 7844 srv_idle
srv_master_thread log flush and writes: 16848
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 56586
OS WAIT ARRAY INFO: signal count 1359584
RW-shared spins 4122909, rounds 7893586, OS waits 20136
RW-excl spins 2187604, rounds 3059458, OS waits 2889
RW-sx spins 479227, rounds 1382571, OS waits 2926
Spin rounds per wait: 1.91 RW-shared, 1.40 RW-excl, 2.89 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 417450126
Purge done for trx's n:o < 417450126 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: 0; buffer pool: 0
84122 OS file reads, 1251442 OS file writes, 159261 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 17.65 writes/s, 8.71 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 94 buffer(s)
Hash table size 2212699, node heap has 191 buffer(s)
Hash table size 2212699, node heap has 58 buffer(s)
Hash table size 2212699, node heap has 87 buffer(s)
Hash table size 2212699, node heap has 88 buffer(s)
Hash table size 2212699, node heap has 88 buffer(s)
504.66 hash searches/s, 51.17 non-hash searches/s
---
LOG
---
Log sequence number 742918081851
Log flushed up to   742918080667
Pages flushed up to 742918080667
Last checkpoint at  742918043002
0 pending log flushes, 0 pending chkp writes
476719 log i/o's done, 3.71 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8623489024
Dictionary memory allocated 324520
Buffer pool size   513728
Free buffers       415977
Database pages     96450
Old database pages 35440
Modified db pages  3
Percent of dirty pages(LRU & free pages): 0.001
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2388, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 83986, created 12464, written 714503
0.00 reads/s, 0.00 creates/s, 10.68 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: 96450, 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       52055
Database pages     12027
Old database pages 4419
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 193, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10505, created 1522, written 104968
0.00 reads/s, 0.00 creates/s, 1.29 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: 12027, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   64216
Free buffers       51702
Database pages     12313
Old database pages 4525
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 1480, written 84499
0.00 reads/s, 0.00 creates/s, 0.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: 12313, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   64216
Free buffers       52157
Database pages     11916
Old database pages 4378
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 1466, written 69811
0.00 reads/s, 0.00 creates/s, 0.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: 11916, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   64216
Free buffers       51853
Database pages     12171
Old database pages 4472
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 191, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10547, created 1624, written 104842
0.00 reads/s, 0.00 creates/s, 3.18 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: 12171, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   64216
Free buffers       52083
Database pages     12004
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 174, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10625, created 1379, written 92199
0.00 reads/s, 0.00 creates/s, 1.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: 12004, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   64216
Free buffers       52080
Database pages     11955
Old database pages 4393
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 427, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10217, created 1738, written 86709
0.00 reads/s, 0.00 creates/s, 2.41 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: 11955, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   64216
Free buffers       52147
Database pages     11928
Old database pages 4383
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 274, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10427, created 1501, written 87836
0.00 reads/s, 0.00 creates/s, 0.38 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: 11928, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   64216
Free buffers       51900
Database pages     12136
Old database pages 4459
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 311, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10382, created 1754, written 83639
0.00 reads/s, 0.00 creates/s, 1.24 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: 12136, 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 341370, updated 20257817, deleted 0, read 3601547289
0.38 inserts/s, 1.88 updates/s, 0.00 deletes/s, 164518.37 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
============================