Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
Variables
|
Buffer Pool
|
InnoDB Status
]
=====================================
2026-11-03 02:13:23 0x3edc INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 21 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 155912 srv_active, 0 srv_shutdown, 1478846 srv_idle
srv_master_thread log flush and writes: 1634710
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 199885399
OS WAIT ARRAY INFO: signal count 177874425
RW-shared spins 290583321, rounds 4043383067, OS waits 77113049
RW-excl spins 293152121, rounds 4738569011, OS waits 98040485
RW-sx spins 37448841, rounds 214758651, OS waits 2306461
Spin rounds per wait: 13.91 RW-shared, 16.16 RW-excl, 5.73 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2026-10-15 07:10:27 0x3f8
*** (1) TRANSACTION:
TRANSACTION 19999068, ACTIVE 14 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 126 lock struct(s), heap size 24696, 15720 row lock(s), undo log entries 7854
MySQL thread id 311, OS thread handle 6520, query id 61829 localhost ::1 ic Updating
DELETE FROM tbl_pr WHERE TOKO = "TIXB"
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 8270 page no 53750 n bits 136 index GEN_CLUST_INDEX of table `new_data_master`.`tbl_pr` trx id 19999068 lock_mode X locks rec but not gap waiting
Record lock, heap no 29 PHYSICAL RECORD: n_fields 50; compact format; info bits 0
0: len 6; hex 00026fe2e161; asc o a;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 1; hex 59; asc Y;;
4: len 5; hex 3333303032; asc 33002;;
5: len 4; hex 813333ac; asc 33 ;;
6: len 18; hex 504f4b454d4f4e204b415254552053563453; asc POKEMON KARTU SV4S;;
7: len 0; hex ; asc ;;
8: len 1; hex 59; asc Y;;
9: len 1; hex 59; asc Y;;
10: len 1; hex 31; asc 1;;
11: len 3; hex 504353; asc PCS;;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: len 4; hex 80004e20; asc N ;;
15: len 4; hex 80000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 1; hex 46; asc F;;
18: len 1; hex 31; asc 1;;
19: len 4; hex 31322e37; asc 12.7;;
20: len 3; hex 362e35; asc 6.5;;
21: len 3; hex 302e32; asc 0.2;;
22: len 0; hex ; asc ;;
23: len 1; hex 4e; asc N;;
24: len 0; hex ; asc ;;
25: len 0; hex ; asc ;;
26: len 1; hex 4e; asc N;;
27: len 1; hex 30; asc 0;;
28: len 1; hex 33; asc 3;;
29: len 30; hex 54544c3d313b54424a3d593b4752423d593b4650443d533b5242583d3330; asc TTL=1;TBJ=Y;GRB=Y;FPD=S;RBX=30; (total 66 bytes);
30: len 1; hex 30; asc 0;;
31: len 2; hex 3133; asc 13;;
32: len 1; hex 30; asc 0;;
33: len 1; hex 30; asc 0;;
34: len 1; hex 31; asc 1;;
35: len 1; hex 30; asc 0;;
36: len 1; hex 33; asc 3;;
37: len 1; hex 32; asc 2;;
38: len 1; hex 30; asc 0;;
39: len 5; hex 3133203133; asc 13 13;;
40: len 4; hex 54495842; asc TIXB;;
41: len 1; hex 30; asc 0;;
42: len 1; hex 30; asc 0;;
43: len 1; hex 30; asc 0;;
44: len 1; hex 30; asc 0;;
45: len 1; hex 30; asc 0;;
46: len 1; hex 30; asc 0;;
47: len 7; hex 504f4b454d4f4e; asc POKEMON;;
48: len 2; hex 3131; asc 11;;
49: len 3; hex 8fd54e; asc N;;
*** (2) TRANSACTION:
TRANSACTION 19999065, ACTIVE 17 sec fetching rows
mysql tables in use 2, locked 2
3330 lock struct(s), heap size 385144, 16337 row lock(s), undo log entries 7897
MySQL thread id 72, OS thread handle 1016, query id 61798 localhost ::1 ic Sending data
INSERT ignore INTO ptag_nr
SELECT
a.TOKO,
a.PRDCD,
a.SINGKATAN,
a.PTAG,
CONCAT(a.TOKO,a.PRDCD,a.PTAG)
FROM tbl_pr a
WHERE a.PTAG IN ("R","N","F")
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 8270 page no 53750 n bits 136 index GEN_CLUST_INDEX of table `new_data_master`.`tbl_pr` trx id 19999065 lock mode S locks rec but not gap
Record lock, heap no 29 PHYSICAL RECORD: n_fields 50; compact format; info bits 0
0: len 6; hex 00026fe2e161; asc o a;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 1; hex 59; asc Y;;
4: len 5; hex 3333303032; asc 33002;;
5: len 4; hex 813333ac; asc 33 ;;
6: len 18; hex 504f4b454d4f4e204b415254552053563453; asc POKEMON KARTU SV4S;;
7: len 0; hex ; asc ;;
8: len 1; hex 59; asc Y;;
9: len 1; hex 59; asc Y;;
10: len 1; hex 31; asc 1;;
11: len 3; hex 504353; asc PCS;;
12: len 4; hex 80000000; asc ;;
13: len 4; hex 80000000; asc ;;
14: len 4; hex 80004e20; asc N ;;
15: len 4; hex 80000000; asc ;;
16: len 4; hex 80000000; asc ;;
17: len 1; hex 46; asc F;;
18: len 1; hex 31; asc 1;;
19: len 4; hex 31322e37; asc 12.7;;
20: len 3; hex 362e35; asc 6.5;;
21: len 3; hex 302e32; asc 0.2;;
22: len 0; hex ; asc ;;
23: len 1; hex 4e; asc N;;
24: len 0; hex ; asc ;;
25: len 0; hex ; asc ;;
26: len 1; hex 4e; asc N;;
27: len 1; hex 30; asc 0;;
28: len 1; hex 33; asc 3;;
29: len 30; hex 54544c3d313b54424a3d593b4752423d593b4650443d533b5242583d3330; asc TTL=1;TBJ=Y;GRB=Y;FPD=S;RBX=30; (total 66 bytes);
30: len 1; hex 30; asc 0;;
31: len 2; hex 3133; asc 13;;
32: len 1; hex 30; asc 0;;
33: len 1; hex 30; asc 0;;
34: len 1; hex 31; asc 1;;
35: len 1; hex 30; asc 0;;
36: len 1; hex 33; asc 3;;
37: len 1; hex 32; asc 2;;
38: len 1; hex 30; asc 0;;
39: len 5; hex 3133203133; asc 13 13;;
40: len 4; hex 54495842; asc TIXB;;
41: len 1; hex 30; asc 0;;
42: len 1; hex 30; asc 0;;
43: len 1; hex 30; asc 0;;
44: len 1; hex 30; asc 0;;
45: len 1; hex 30; asc 0;;
46: len 1; hex 30; asc 0;;
47: len 7; hex 504f4b454d4f4e; asc POKEMON;;
48: len 2; hex 3131; asc 11;;
49: len 3; hex 8fd54e; asc N;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 8270 page no 67 n bits 1192 index PTAG of table `new_data_master`.`tbl_pr` trx id 19999065 lock mode S waiting
Record lock, heap no 345 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 1; hex 4e; asc N;;
1: len 6; hex 00026fe2c2ec; asc o ;;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 20647932
Purge done for trx's n:o < 20647932 undo n:o < 0 state: running but idle
History list length 11
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283711886508464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886500128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886495960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886504296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886491792, 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
476168503 OS file reads, 103632414 OS file writes, 12567436 OS fsyncs
523.83 reads/s, 16384 avg bytes/read, 10.29 writes/s, 3.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 76815, seg size 76817, 5247417 merges
merged operations:
insert 17720267, delete mark 718618608, delete 88163418
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 2413 buffer(s)
Hash table size 1106407, node heap has 2355 buffer(s)
Hash table size 1106407, node heap has 2397 buffer(s)
Hash table size 1106407, node heap has 2035 buffer(s)
Hash table size 1106407, node heap has 2200 buffer(s)
Hash table size 1106407, node heap has 2393 buffer(s)
Hash table size 1106407, node heap has 1812 buffer(s)
Hash table size 1106407, node heap has 1723 buffer(s)
30923.91 hash searches/s, 3801.30 non-hash searches/s
---
LOG
---
Log sequence number 12062525544524
Log flushed up to 12062525544504
Pages flushed up to 12062525542093
Last checkpoint at 12062525524586
0 pending log flushes, 0 pending chkp writes
1096241 log i/o's done, 1.29 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 5905580032
Dictionary memory allocated 9452600
Buffer pool size 256864
Free buffers 8335
Database pages 231137
Old database pages 85173
Modified db pages 5
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 96116313, not young 71132256578
136.42 youngs/s, 76729.39 non-youngs/s
Pages read 476130660, created 8238850, written 97600467
523.88 reads/s, 0.00 creates/s, 8.14 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 706 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 231137, unzip_LRU len: 0
I/O sum[448544]:cur[32], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 32108
Free buffers 1037
Database pages 28871
Old database pages 10646
Modified db pages 2
Percent of dirty pages(LRU & free pages): 0.007
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12091202, not young 8997560438
18.71 youngs/s, 9628.11 non-youngs/s
Pages read 60132093, created 1274521, written 12422963
64.00 reads/s, 0.00 creates/s, 4.86 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 688 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28871, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 32108
Free buffers 1072
Database pages 28881
Old database pages 10641
Modified db pages 1
Percent of dirty pages(LRU & free pages): 0.003
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11871119, not young 8939298234
15.67 youngs/s, 8841.82 non-youngs/s
Pages read 59752287, created 993798, written 12298142
60.76 reads/s, 0.00 creates/s, 0.24 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 699 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28881, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 32108
Free buffers 1056
Database pages 28871
Old database pages 10637
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12298409, not young 8602690576
16.86 youngs/s, 9583.78 non-youngs/s
Pages read 58831598, created 982520, written 12213844
65.19 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 717 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28871, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 32108
Free buffers 1056
Database pages 28816
Old database pages 10617
Modified db pages 2
Percent of dirty pages(LRU & free pages): 0.007
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11651814, not young 8856936168
15.62 youngs/s, 8689.16 non-youngs/s
Pages read 59221428, created 988809, written 12264598
61.33 reads/s, 0.00 creates/s, 2.57 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 707 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28816, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 32108
Free buffers 1044
Database pages 28935
Old database pages 10661
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11920831, not young 8830942699
16.57 youngs/s, 9821.29 non-youngs/s
Pages read 59418040, created 993417, written 12094126
66.57 reads/s, 0.00 creates/s, 0.48 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 715 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28935, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 32108
Free buffers 1024
Database pages 28900
Old database pages 10650
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11779538, not young 9002338727
17.71 youngs/s, 10198.04 non-youngs/s
Pages read 59583003, created 991658, written 11990992
68.66 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 712 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28900, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 32108
Free buffers 1025
Database pages 28909
Old database pages 10652
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12441269, not young 8916283756
17.43 youngs/s, 9634.54 non-youngs/s
Pages read 59653425, created 1015262, written 12099572
64.28 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 995 / 1000, young-making rate 1 / 1000 not 696 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28909, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 32108
Free buffers 1021
Database pages 28954
Old database pages 10669
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12062131, not young 8986205980
17.86 youngs/s, 10332.65 non-youngs/s
Pages read 59538786, created 998865, written 12216230
73.09 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 994 / 1000, young-making rate 1 / 1000 not 714 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28954, unzip_LRU len: 0
I/O sum[56068]:cur[4], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=4208, Main thread ID=17144, state: sleeping
Number of rows inserted 447726529, updated 5184, deleted 379539389, read 58182613302
0.00 inserts/s, 0.71 updates/s, 0.00 deletes/s, 34712.01 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 11370
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
