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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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-10-20 01:52:47 0x4f5c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 50 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1757889 srv_active, 0 srv_shutdown, 36496 srv_idle
srv_master_thread log flush and writes: 1794364
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 431941235
OS WAIT ARRAY INFO: signal count 556347269
RW-shared spins 742435197, rounds 11419108426, OS waits 221092865
RW-excl spins 642400284, rounds 8825659829, OS waits 158110425
RW-sx spins 35082449, rounds 351451301, OS waits 5353686
Spin rounds per wait: 15.38 RW-shared, 13.74 RW-excl, 10.02 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 2600812848
Purge done for trx's n:o < 2587812750 undo n:o < 0 state: running but idle
History list length 6383937
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 282891049374128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282891049369960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282891049365792, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 5381838, OS thread handle 20796, query id 1827221593 localhost 127.0.0.1 root Creating sort index
SELECT * FROM `sms_records` ORDER BY `updated_at` ASC LIMIT 0, 25
Trx read view will not see trx with id >= 2600812846, sees < 2600812846
---TRANSACTION 282891049361624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 282891049357456, ACTIVE 60950 sec
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 5185071, OS thread handle 18496, query id 1821885686 localhost 127.0.0.1 root 
Trx read view will not see trx with id >= 2587812746, sees < 2587812740
--------
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
2137249098 OS file reads, 2310894135 OS file writes, 286458726 OS fsyncs
1 pending reads, 0 pending writes
602.09 reads/s, 16384 avg bytes/read, 436.87 writes/s, 57.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 2727, free list len 37485, seg size 40213, 191119003 merges
merged operations:
 insert 553170293, delete mark 987699158, delete 8572524
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 553253, node heap has 2792 buffer(s)
Hash table size 553253, node heap has 167 buffer(s)
Hash table size 553253, node heap has 25 buffer(s)
Hash table size 553253, node heap has 7 buffer(s)
Hash table size 553253, node heap has 4 buffer(s)
Hash table size 553253, node heap has 5 buffer(s)
Hash table size 553253, node heap has 37 buffer(s)
Hash table size 553253, node heap has 6 buffer(s)
1699.63 hash searches/s, 4764.86 non-hash searches/s
---
LOG
---
Log sequence number 4797986052932
Log flushed up to   4797986052932
Pages flushed up to 4797985675490
Last checkpoint at  4797984674951
0 pending log flushes, 0 pending chkp writes
154095722 log i/o's done, 5.78 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2281701376
Dictionary memory allocated 262920
Buffer pool size   128432
Free buffers       6071
Database pages     119318
Old database pages 44201
Modified db pages  576
Percent of dirty pages(LRU & free pages): 0.459
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1300560504, not young 96470736017
218.80 youngs/s, 4098.40 non-youngs/s
Pages read 2137248989, created 22656422, written 2097667143
602.07 reads/s, 5.14 creates/s, 410.11 writes/s
Buffer pool hit rate 982 / 1000, young-making rate 6 / 1000 not 122 / 1000
Pages read ahead 6.82/s, evicted without access 0.86/s, Random read ahead 0.00/s
LRU len: 119318, unzip_LRU len: 0
I/O sum[376568]:cur[20064], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   16054
Free buffers       818
Database pages     14860
Old database pages 5505
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.013
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 178632391, not young 12475774062
74.94 youngs/s, 159.24 non-youngs/s
Pages read 261063843, created 2880957, written 260815869
19.46 reads/s, 0.24 creates/s, 40.44 writes/s
Buffer pool hit rate 993 / 1000, young-making rate 25 / 1000 not 54 / 1000
Pages read ahead 2.56/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 14860, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16054
Free buffers       718
Database pages     14974
Old database pages 5547
Modified db pages  13
Percent of dirty pages(LRU & free pages): 0.083
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 130027703, not young 11651503017
42.74 youngs/s, 259.63 non-youngs/s
Pages read 252659107, created 2843104, written 251926713
37.34 reads/s, 0.32 creates/s, 47.16 writes/s
Buffer pool hit rate 987 / 1000, young-making rate 13 / 1000 not 83 / 1000
Pages read ahead 0.10/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 14974, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16054
Free buffers       781
Database pages     14880
Old database pages 5512
Modified db pages  126
Percent of dirty pages(LRU & free pages): 0.804
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 216661028, not young 12964359555
0.54 youngs/s, 857.18 non-youngs/s
Pages read 293857742, created 2790078, written 276878260
131.20 reads/s, 0.74 creates/s, 55.24 writes/s
Buffer pool hit rate 985 / 1000, young-making rate 0 / 1000 not 92 / 1000
Pages read ahead 0.00/s, evicted without access 0.26/s, Random read ahead 0.00/s
LRU len: 14880, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16054
Free buffers       745
Database pages     14922
Old database pages 5528
Modified db pages  127
Percent of dirty pages(LRU & free pages): 0.811
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 149175764, not young 11715387234
9.58 youngs/s, 753.92 non-youngs/s
Pages read 268342000, created 2815356, written 263872304
105.82 reads/s, 1.74 creates/s, 55.48 writes/s
Buffer pool hit rate 969 / 1000, young-making rate 2 / 1000 not 219 / 1000
Pages read ahead 2.56/s, evicted without access 0.12/s, Random read ahead 0.00/s
LRU len: 14922, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16054
Free buffers       733
Database pages     14915
Old database pages 5525
Modified db pages  149
Percent of dirty pages(LRU & free pages): 0.952
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 144174457, not young 11616667953
29.60 youngs/s, 340.33 non-youngs/s
Pages read 258488625, created 2836204, written 275391020
51.60 reads/s, 1.18 creates/s, 58.46 writes/s
Buffer pool hit rate 989 / 1000, young-making rate 6 / 1000 not 69 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 14915, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16054
Free buffers       819
Database pages     14841
Old database pages 5498
Modified db pages  35
Percent of dirty pages(LRU & free pages): 0.223
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 199815666, not young 12782913750
6.14 youngs/s, 639.09 non-youngs/s
Pages read 292849572, created 2833395, written 263930677
96.62 reads/s, 0.24 creates/s, 51.10 writes/s
Buffer pool hit rate 972 / 1000, young-making rate 1 / 1000 not 181 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 14841, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16054
Free buffers       691
Database pages     15007
Old database pages 5559
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.013
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 139185846, not young 11426629513
53.66 youngs/s, 314.65 non-youngs/s
Pages read 246316753, created 2819374, written 251343162
43.78 reads/s, 0.24 creates/s, 46.70 writes/s
Buffer pool hit rate 987 / 1000, young-making rate 15 / 1000 not 88 / 1000
Pages read ahead 1.28/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 15007, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16054
Free buffers       766
Database pages     14919
Old database pages 5527
Modified db pages  122
Percent of dirty pages(LRU & free pages): 0.778
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 142887649, not young 11837500933
1.60 youngs/s, 774.34 non-youngs/s
Pages read 263671347, created 2837954, written 253509138
116.26 reads/s, 0.44 creates/s, 55.54 writes/s
Buffer pool hit rate 958 / 1000, young-making rate 0 / 1000 not 274 / 1000
Pages read ahead 0.32/s, evicted without access 0.48/s, Random read ahead 0.00/s
LRU len: 14919, unzip_LRU len: 0
I/O sum[47071]:cur[2508], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Process ID=4344, Main thread ID=5928, state: sleeping
Number of rows inserted 410221349, updated 314465187, deleted 409206864, read 235560663768
0.16 inserts/s, 92.22 updates/s, 0.00 deletes/s, 57715.21 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 345909
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================