Console
Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
=====================================
2026-11-03 01:38:35 0x17f0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 31 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 155649 srv_active, 0 srv_shutdown, 1477087 srv_idle
srv_master_thread log flush and writes: 1632688
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 199797178
OS WAIT ARRAY INFO: signal count 177801145
RW-shared spins 290454048, rounds 4042500811, OS waits 77104485
RW-excl spins 293097005, rounds 4738220623, OS waits 98039282
RW-sx spins 37448841, rounds 214758651, OS waits 2306461
Spin rounds per wait: 13.92 RW-shared, 16.17 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 20642128
Purge done for trx's n:o < 20642095 undo n:o < 0 state: running but idle
History list length 17
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283711886495960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886533472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886525136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886512632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886520968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886508464, 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 283711886516800, ACTIVE 12 sec fetching rows
mysql tables in use 1563, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 58736, OS thread handle 2072, query id 3613390 localhost 127.0.0.1 root Sending data
SELECT * FROM `tbv_nkl_auto` LIMIT 0, 25
Trx read view will not see trx with id >= 20642094, sees < 20642094
---TRANSACTION 283711886500128, 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
474107782 OS file reads, 103628660 OS file writes, 12565105 OS fsyncs
1 pending reads, 0 pending writes
1062.39 reads/s, 16383 avg bytes/read, 9.74 writes/s, 5.77 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 923 buffer(s)
Hash table size 1106407, node heap has 1231 buffer(s)
Hash table size 1106407, node heap has 807 buffer(s)
Hash table size 1106407, node heap has 849 buffer(s)
Hash table size 1106407, node heap has 955 buffer(s)
Hash table size 1106407, node heap has 732 buffer(s)
Hash table size 1106407, node heap has 700 buffer(s)
Hash table size 1106407, node heap has 837 buffer(s)
34723.56 hash searches/s, 5305.28 non-hash searches/s
---
LOG
---
Log sequence number 12062524872581
Log flushed up to 12062524872581
Pages flushed up to 12062524871425
Last checkpoint at 12062524860608
0 pending log flushes, 0 pending chkp writes
1095188 log i/o's done, 2.48 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 5905580032
Dictionary memory allocated 6237464
Buffer pool size 256864
Free buffers 8228
Database pages 240250
Old database pages 88535
Modified db pages 3
Percent of dirty pages(LRU & free pages): 0.001
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 95960610, not young 70811203982
89.26 youngs/s, 94242.86 non-youngs/s
Pages read 474098891, created 8238843, written 97598405
1062.35 reads/s, 0.00 creates/s, 5.61 writes/s
Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 770 / 1000
Pages read ahead 138.32/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 240250, unzip_LRU len: 2620
I/O sum[233928]:cur[80], unzip sum[16]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 32108
Free buffers 1039
Database pages 30039
Old database pages 11068
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 12070842, not young 8956645573
9.64 youngs/s, 10717.69 non-youngs/s
Pages read 59880895, created 1274514, written 12421869
128.61 reads/s, 0.00 creates/s, 2.58 writes/s
Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 719 / 1000
Pages read ahead 18.58/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30039, unzip_LRU len: 223
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
---BUFFER POOL 1
Buffer pool size 32108
Free buffers 1042
Database pages 29903
Old database pages 11018
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 11852966, not young 8900306011
7.97 youngs/s, 11652.59 non-youngs/s
Pages read 59498526, created 993798, written 12297936
131.19 reads/s, 0.00 creates/s, 0.55 writes/s
Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 792 / 1000
Pages read ahead 16.52/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 29903, unzip_LRU len: 514
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
---BUFFER POOL 2
Buffer pool size 32108
Free buffers 1033
Database pages 29994
Old database pages 11052
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 12278853, not young 8562739698
18.52 youngs/s, 12978.58 non-youngs/s
Pages read 58578853, created 982520, written 12213844
152.09 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 990 / 1000, young-making rate 1 / 1000 not 813 / 1000
Pages read ahead 18.58/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 29994, unzip_LRU len: 407
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
---BUFFER POOL 3
Buffer pool size 32108
Free buffers 1037
Database pages 29957
Old database pages 11038
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 11632880, not young 8817013231
7.45 youngs/s, 11694.11 non-youngs/s
Pages read 58971359, created 988809, written 12264157
122.64 reads/s, 0.00 creates/s, 2.48 writes/s
Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 755 / 1000
Pages read ahead 12.39/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 29957, unzip_LRU len: 457
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
---BUFFER POOL 4
Buffer pool size 32108
Free buffers 1024
Database pages 30138
Old database pages 11105
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 11901361, not young 8790076622
9.06 youngs/s, 12908.42 non-youngs/s
Pages read 59164293, created 993417, written 12093805
129.87 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 789 / 1000
Pages read ahead 14.45/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30138, unzip_LRU len: 246
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
---BUFFER POOL 5
Buffer pool size 32108
Free buffers 1023
Database pages 30043
Old database pages 11070
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 11760394, not young 8962457199
9.64 youngs/s, 11965.39 non-youngs/s
Pages read 59329892, created 991658, written 11990992
134.54 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 791 / 1000
Pages read ahead 12.39/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30043, unzip_LRU len: 283
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
---BUFFER POOL 6
Buffer pool size 32108
Free buffers 1023
Database pages 30077
Old database pages 11082
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 12421178, not young 8875402273
18.45 youngs/s, 10933.78 non-youngs/s
Pages read 59394559, created 1015262, written 12099572
140.58 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 990 / 1000, young-making rate 1 / 1000 not 710 / 1000
Pages read ahead 22.71/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30077, unzip_LRU len: 255
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
---BUFFER POOL 7
Buffer pool size 32108
Free buffers 1007
Database pages 30099
Old database pages 11102
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12042136, not young 8946563375
8.52 youngs/s, 11392.31 non-youngs/s
Pages read 59280514, created 998865, written 12216230
122.83 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 786 / 1000
Pages read ahead 22.71/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30099, unzip_LRU len: 235
I/O sum[29241]:cur[10], unzip sum[2]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=4208, Main thread ID=17144, state: sleeping
Number of rows inserted 447726529, updated 4626, deleted 379539389, read 58063641278
0.00 inserts/s, 1.55 updates/s, 0.00 deletes/s, 40605.40 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
============================