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:12:33 0x7001d80576c0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 49 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 7674 srv_active, 0 srv_shutdown, 6978 srv_idle
srv_master_thread log flush and writes: 14651
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 55172
OS WAIT ARRAY INFO: signal count 1351017
RW-shared spins 4093875, rounds 7826358, OS waits 19220
RW-excl spins 2176362, rounds 3040401, OS waits 2862
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 417392160
Purge done for trx's n:o < 417392160 undo n:o < 0 state: running
History list length 8
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 404628429705840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 404628429697408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 404628429701624, 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)
---TRANSACTION 404628429693192, 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, 1194743 OS file writes, 141228 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 25.20 writes/s, 8.88 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 611 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)
367.77 hash searches/s, 85.65 non-hash searches/s
---
LOG
---
Log sequence number 742843045292
Log flushed up to   742843037103
Pages flushed up to 742842994968
Last checkpoint at  742842963316
0 pending log flushes, 0 pending chkp writes
448680 log i/o's done, 5.55 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8623489024
Dictionary memory allocated 324520
Buffer pool size   513728
Free buffers       416486
Database pages     95996
Old database pages 35277
Modified db pages  95
Percent of dirty pages(LRU & free pages): 0.019
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2385, not young 0
0.02 youngs/s, 0.00 non-youngs/s
Pages read 83986, created 12010, written 692173
0.00 reads/s, 0.02 creates/s, 16.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: 95996, 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       52134
Database pages     11956
Old database pages 4393
Modified db pages  21
Percent of dirty pages(LRU & free pages): 0.033
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 1451, written 99250
0.00 reads/s, 0.00 creates/s, 4.12 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: 11956, 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.02 youngs/s, 0.00 non-youngs/s
Pages read 10833, created 1472, written 83512
0.00 reads/s, 0.00 creates/s, 0.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: 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 69114
0.00 reads/s, 0.00 creates/s, 0.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: 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  39
Percent of dirty pages(LRU & free pages): 0.061
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 100838
0.00 reads/s, 0.00 creates/s, 3.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: 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  11
Percent of dirty pages(LRU & free pages): 0.017
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 172, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10625, created 1365, written 87924
0.00 reads/s, 0.00 creates/s, 3.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: 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       52140
Database pages     11901
Old database pages 4373
Modified db pages  15
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 427, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10217, created 1684, written 83943
0.00 reads/s, 0.00 creates/s, 2.65 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: 11901, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   64216
Free buffers       52253
Database pages     11828
Old database pages 4346
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 1401, written 86241
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: 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       52061
Database pages     11982
Old database pages 4407
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 310, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10382, created 1600, written 81351
0.00 reads/s, 0.02 creates/s, 2.08 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: 11982, 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 307205, updated 20114729, deleted 0, read 3208126793
0.43 inserts/s, 3.67 updates/s, 0.00 deletes/s, 199557.34 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 4321
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================