Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Storage engines

InnoDB Documentation

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

[ Variables | Buffer Pool | InnoDB Status ]


=====================================
2026-11-21 07:01:27 0x65c8 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 49 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 233122 srv_active, 0 srv_shutdown, 642035 srv_idle
srv_master_thread log flush and writes: 875157
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3560158
OS WAIT ARRAY INFO: signal count 1741564
RW-shared spins 0, rounds 1756612, OS waits 694525
RW-excl spins 0, rounds 5979610, OS waits 9132
RW-sx spins 77839, rounds 616096, OS waits 2870
Spin rounds per wait: 1756612.00 RW-shared, 5979610.00 RW-excl, 7.92 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 37141800
Purge done for trx's n:o < 37141800 undo n:o < 0 state: running
History list length 8
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283026422892248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422883816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422888032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422871168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422879600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422875384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422866952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422862736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422858520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422854304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422845872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422841656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422837440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 283026422850088, not started
0 lock struct(s), heap size 1136, 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
11106 OS file reads, 22631392 OS file writes, 11253146 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 22.31 writes/s, 11.59 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 110, seg size 112, 1103 merges
merged operations:
 insert 1411, delete mark 454, delete 444
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 553253, node heap has 3 buffer(s)
Hash table size 553253, node heap has 10 buffer(s)
Hash table size 553253, node heap has 3 buffer(s)
Hash table size 553253, node heap has 59 buffer(s)
Hash table size 553253, node heap has 9 buffer(s)
Hash table size 553253, node heap has 2 buffer(s)
Hash table size 553253, node heap has 2 buffer(s)
Hash table size 553253, node heap has 2 buffer(s)
7.92 hash searches/s, 18.39 non-hash searches/s
---
LOG
---
Log sequence number 95428784831
Log flushed up to   95428784584
Pages flushed up to 95428770561
Last checkpoint at  95428770139
0 pending log flushes, 0 pending chkp writes
3599901 log i/o's done, 3.82 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2181038080
Dictionary memory allocated 935712
Buffer pool size   128304
Free buffers       96622
Database pages     31592
Old database pages 11725
Modified db pages  108
Percent of dirty pages(LRU & free pages): 0.084
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1442, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10681, created 20911, written 16582456
0.00 reads/s, 0.00 creates/s, 15.63 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: 31592, 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   16038
Free buffers       11450
Database pages     4577
Old database pages 1669
Modified db pages  15
Percent of dirty pages(LRU & free pages): 0.094
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 114, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1720, created 2857, written 2517918
0.00 reads/s, 0.00 creates/s, 2.76 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: 4577, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16038
Free buffers       12078
Database pages     3952
Old database pages 1457
Modified db pages  8
Percent of dirty pages(LRU & free pages): 0.050
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 393, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1367, created 2585, written 1267516
0.00 reads/s, 0.00 creates/s, 1.51 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: 3952, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16038
Free buffers       12385
Database pages     3636
Old database pages 1362
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.006
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 126, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1143, created 2493, written 1215926
0.00 reads/s, 0.00 creates/s, 1.16 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: 3636, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16038
Free buffers       11989
Database pages     4042
Old database pages 1511
Modified db pages  42
Percent of dirty pages(LRU & free pages): 0.262
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 115, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1353, created 2689, written 2902899
0.00 reads/s, 0.00 creates/s, 2.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: 4042, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16038
Free buffers       12087
Database pages     3935
Old database pages 1471
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.012
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 190, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1363, created 2572, written 2417934
0.00 reads/s, 0.00 creates/s, 2.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: 3935, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16038
Free buffers       12382
Database pages     3646
Old database pages 1365
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.031
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 76, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1188, created 2458, written 1771453
0.00 reads/s, 0.00 creates/s, 0.82 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: 3646, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16038
Free buffers       12239
Database pages     3790
Old database pages 1416
Modified db pages  21
Percent of dirty pages(LRU & free pages): 0.131
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 154, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1169, created 2621, written 2464570
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: 3790, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16038
Free buffers       12012
Database pages     4014
Old database pages 1474
Modified db pages  14
Percent of dirty pages(LRU & free pages): 0.087
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 1378, created 2636, written 2024240
0.00 reads/s, 0.00 creates/s, 2.20 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: 4014, 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=24536, Main thread ID=26084, state: sleeping
Number of rows inserted 1273416, updated 817170, deleted 694332, read 42923746
1.18 inserts/s, 0.86 updates/s, 0.27 deletes/s, 6.82 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 75488
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================