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:53:01 0x3ef8 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 43 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 9230 srv_active, 0 srv_shutdown, 637714 srv_idle
srv_master_thread log flush and writes: 646944
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 314205
OS WAIT ARRAY INFO: signal count 94620
RW-shared spins 20653, rounds 400038, OS waits 11467
RW-excl spins 7833, rounds 17786, OS waits 90
RW-sx spins 2142, rounds 10363, OS waits 66
Spin rounds per wait: 19.37 RW-shared, 2.27 RW-excl, 4.84 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 179719
Purge done for trx's n:o < 179719 undo n:o < 0 state: running
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284174855987416, 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, 116274 OS file writes, 77079 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 4.02 writes/s, 2.21 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)
4.70 hash searches/s, 10.95 non-hash searches/s
---
LOG
---
Log sequence number 406460200
Log flushed up to 406460200
Pages flushed up to 406455508
Last checkpoint at 406455411
0 pending log flushes, 0 pending chkp writes
47316 log i/o's done, 1.33 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 21
Percent of dirty pages(LRU & free pages): 0.065
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 58647
0.00 reads/s, 0.00 creates/s, 2.37 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[2], 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 17139, deleted 17244, read 1519009
0.00 inserts/s, 0.63 updates/s, 0.00 deletes/s, 4.47 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 22195
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
