Mecanismos de armazenamento

InnoDB

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

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

=====================================
2026-09-15 22:11:06 0x4160 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 8396 srv_active, 0 srv_shutdown, 636103 srv_idle
srv_master_thread log flush and writes: 644499
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 281091
OS WAIT ARRAY INFO: signal count 91475
RW-shared spins 20325, rounds 390365, OS waits 11320
RW-excl spins 7811, rounds 17298, OS waits 82
RW-sx spins 2142, rounds 10363, OS waits 66
Spin rounds per wait: 19.21 RW-shared, 2.21 RW-excl, 4.84 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 176033
Purge done for trx's n:o < 176033 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284174855987416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284174856008256, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284174856004088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284174855999920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284174855983248, 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
6504 OS file reads, 104371 OS file writes, 71026 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 12.12 writes/s, 5.87 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 2 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 1 buffer(s)
Hash table size 138401, node heap has 3 buffer(s)
Hash table size 138401, node heap has 2 buffer(s)
13.62 hash searches/s, 36.50 non-hash searches/s
---
LOG
---
Log sequence number 404169020
Log flushed up to   404168500
Pages flushed up to 404163892
Last checkpoint at  404147614
0 pending log flushes, 0 pending chkp writes
43949 log i/o's done, 3.62 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 671088640
Dictionary memory allocated 460736
Buffer pool size   32108
Free buffers       25577
Database pages     6515
Old database pages 2403
Modified db pages  23
Percent of dirty pages(LRU & free pages): 0.072
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 6323, created 192, written 51152
0.00 reads/s, 0.00 creates/s, 7.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: 6515, 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=3960, Main thread ID=5224, state: sleeping
Number of rows inserted 866, updated 15298, deleted 17244, read 1433321
0.00 inserts/s, 2.50 updates/s, 0.00 deletes/s, 13.62 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 19027
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================