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 12:45:58 0x7001e4b506c0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 4 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 30824 srv_active, 0 srv_shutdown, 14523 srv_idle
srv_master_thread log flush and writes: 45346
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 134152
OS WAIT ARRAY INFO: signal count 1494309
RW-shared spins 4528481, rounds 8716941, OS waits 29792
RW-excl spins 2333824, rounds 3316398, OS waits 3170
RW-sx spins 479605, rounds 1385751, OS waits 2933
Spin rounds per wait: 1.92 RW-shared, 1.42 RW-excl, 2.89 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 418312640
Purge done for trx's n:o < 418312640 undo n:o < 0 state: running
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 404628429697408, 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, 2130395 OS file writes, 462565 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 16.00 writes/s, 8.75 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 178 buffer(s)
Hash table size 2212699, node heap has 198 buffer(s)
Hash table size 2212699, node heap has 198 buffer(s)
424.89 hash searches/s, 65.73 non-hash searches/s
---
LOG
---
Log sequence number 744089802030
Log flushed up to   744089800633
Pages flushed up to 744089800633
Last checkpoint at  744089791270
0 pending log flushes, 0 pending chkp writes
877275 log i/o's done, 3.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 8623489024
Dictionary memory allocated 324520
Buffer pool size   513728
Free buffers       408145
Database pages     103482
Old database pages 38036
Modified db pages  9
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 2570, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 83986, created 19496, written 1084378
0.00 reads/s, 0.00 creates/s, 10.00 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: 103482, 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       51105
Database pages     12875
Old database pages 4732
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.003
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 2370, written 177686
0.00 reads/s, 0.00 creates/s, 2.25 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: 12875, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   64216
Free buffers       50776
Database pages     13145
Old database pages 4832
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 385, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10833, created 2312, written 107921
0.00 reads/s, 0.00 creates/s, 0.00 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: 13145, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   64216
Free buffers       51178
Database pages     12787
Old database pages 4700
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 471, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10450, created 2337, written 93408
0.00 reads/s, 0.00 creates/s, 0.50 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: 12787, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   64216
Free buffers       50930
Database pages     13000
Old database pages 4778
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 215, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10547, created 2453, written 163555
0.00 reads/s, 0.00 creates/s, 0.00 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: 13000, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   64216
Free buffers       51093
Database pages     12877
Old database pages 4733
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 206, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10625, created 2252, written 151619
0.00 reads/s, 0.00 creates/s, 4.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: 12877, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   64216
Free buffers       51075
Database pages     12863
Old database pages 4728
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 459, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10217, created 2646, written 126175
0.00 reads/s, 0.00 creates/s, 1.25 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: 12863, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   64216
Free buffers       51181
Database pages     12806
Old database pages 4707
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 285, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10427, created 2379, written 133017
0.00 reads/s, 0.00 creates/s, 1.00 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: 12806, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   64216
Free buffers       50807
Database pages     13129
Old database pages 4826
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 2747, written 130997
0.00 reads/s, 0.00 creates/s, 0.25 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: 13129, 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 875013, updated 22521730, deleted 0, read 13483617689
0.25 inserts/s, 1.50 updates/s, 0.00 deletes/s, 160284.68 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, 488.13 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================