Mecanismos de armazenamento

InnoDB

Supports transactions, row-level locking, foreign keys and encryption for tables

[ Variáveis | Pool de buffer | Status do InnoDB ]

=====================================
2026-11-02 11:34:54 0x2844 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 22 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 15272 srv_active, 0 srv_shutdown, 622685 srv_idle
srv_master_thread log flush and writes: 637957
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1024804
OS WAIT ARRAY INFO: signal count 339399
RW-shared spins 326314, rounds 7598210, OS waits 80182
RW-excl spins 11577, rounds 53204, OS waits 517
RW-sx spins 1227, rounds 9142, OS waits 82
Spin rounds per wait: 23.28 RW-shared, 4.60 RW-excl, 7.45 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 1216219
Purge done for trx's n:o < 1216219 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283303474176288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474172120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474222136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474213800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474180456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474167952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474197128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474192960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474188792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283303474184624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: native aio handle (insert buffer thread)
I/O thread 1 state: native aio handle (log thread)
I/O thread 2 state: native aio handle (read thread)
I/O thread 3 state: native aio handle (read thread)
I/O thread 4 state: native aio handle (read thread)
I/O thread 5 state: native aio handle (read thread)
I/O thread 6 state: native aio handle (write thread)
I/O thread 7 state: native aio handle (write thread)
I/O thread 8 state: native aio handle (write thread)
I/O thread 9 state: native aio handle (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
2444823 OS file reads, 736750 OS file writes, 308466 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 9.68 writes/s, 3.73 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 138401, node heap has 3 buffer(s)
Hash table size 138401, node heap has 1 buffer(s)
Hash table size 138401, node heap has 1 buffer(s)
Hash table size 138401, node heap has 2 buffer(s)
Hash table size 138401, node heap has 2 buffer(s)
Hash table size 138401, node heap has 2 buffer(s)
Hash table size 138401, node heap has 2 buffer(s)
Hash table size 138401, node heap has 1 buffer(s)
9.95 hash searches/s, 23.64 non-hash searches/s
---
LOG
---
Log sequence number 5139546971
Log flushed up to   5139546389
Pages flushed up to 5139542909
Last checkpoint at  5139542900
0 pending log flushes, 0 pending chkp writes
202649 log i/o's done, 2.59 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 671088640
Dictionary memory allocated 653544
Buffer pool size   32108
Free buffers       1024
Database pages     31070
Old database pages 11449
Modified db pages  25
Percent of dirty pages(LRU & free pages): 0.078
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1017550, not young 3453316
0.23 youngs/s, 0.00 non-youngs/s
Pages read 2444562, created 159811, written 488853
0.00 reads/s, 0.00 creates/s, 6.59 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 31070, unzip_LRU len: 0
I/O sum[286]: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=3924, Main thread ID=5576, state: sleeping
Number of rows inserted 5418, updated 117250, deleted 4761, read 21810366
0.00 inserts/s, 1.68 updates/s, 0.00 deletes/s, 20.32 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 473721
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================