Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
Variables
|
Buffer Pool
|
InnoDB Status
]
=====================================
2026-11-02 23:13:49 0x4818 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 60 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 154032 srv_active, 0 srv_shutdown, 1470336 srv_idle
srv_master_thread log flush and writes: 1624320
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 199250171
OS WAIT ARRAY INFO: signal count 177499360
RW-shared spins 290215887, rounds 4038619834, OS waits 77019488
RW-excl spins 293019522, rounds 4737841212, OS waits 98035905
RW-sx spins 37448839, rounds 214758647, 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 20619485
Purge done for trx's n:o < 20618809 undo n:o < 0 state: running but idle
History list length 338
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283711886516800, 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 283711886495960, 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 283711886529304, ACTIVE 28 sec fetching rows
mysql tables in use 2, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 54226, OS thread handle 19000, query id 3363869 localhost 127.0.0.1 root Sending data
SELECT * FROM `tbv_data_dc` LIMIT 0, 25
Trx read view will not see trx with id >= 20619369, sees < 20619369
---TRANSACTION 283711886520968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283711886512632, ACTIVE 2143 sec
mysql tables in use 2, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 53372, OS thread handle 4624, query id 3319140 localhost 127.0.0.1 root Sending data
SELECT * FROM `tbv_data_dc` LIMIT 0, 25
Trx read view will not see trx with id >= 20618808, sees < 20618808
---TRANSACTION 283711886508464, 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
462891012 OS file reads, 103612572 OS file writes, 12551407 OS fsyncs
560.54 reads/s, 16384 avg bytes/read, 7.45 writes/s, 5.63 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 1097 buffer(s)
Hash table size 1106407, node heap has 1128 buffer(s)
Hash table size 1106407, node heap has 1153 buffer(s)
Hash table size 1106407, node heap has 1146 buffer(s)
Hash table size 1106407, node heap has 1107 buffer(s)
Hash table size 1106407, node heap has 1199 buffer(s)
Hash table size 1106407, node heap has 894 buffer(s)
Hash table size 1106407, node heap has 848 buffer(s)
23353.38 hash searches/s, 3991.32 non-hash searches/s
---
LOG
---
Log sequence number 12062522333332
Log flushed up to 12062522333332
Pages flushed up to 12062522326254
Last checkpoint at 12062522322678
0 pending log flushes, 0 pending chkp writes
1090025 log i/o's done, 2.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 5905580032
Dictionary memory allocated 6237464
Buffer pool size 256864
Free buffers 7730
Database pages 240498
Old database pages 88859
Modified db pages 13
Percent of dirty pages(LRU & free pages): 0.005
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 95129263, not young 70160101610
22.93 youngs/s, 23629.99 non-youngs/s
Pages read 462882123, created 8238720, written 97591747
560.56 reads/s, 0.02 creates/s, 3.63 writes/s
Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 218 / 1000
Pages read ahead 327.44/s, evicted without access 0.95/s, Random read ahead 0.00/s
LRU len: 240498, unzip_LRU len: 3
I/O sum[112176]:cur[1152], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 32108
Free buffers 919
Database pages 30153
Old database pages 11150
Modified db pages 6
Percent of dirty pages(LRU & free pages): 0.019
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11970118, not young 8875648249
1.85 youngs/s, 3124.93 non-youngs/s
Pages read 58477892, created 1274391, written 12418674
70.27 reads/s, 0.02 creates/s, 1.43 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 38 / 1000
Pages read ahead 42.67/s, evicted without access 0.95/s, Random read ahead 0.00/s
LRU len: 30153, unzip_LRU len: 1
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 32108
Free buffers 953
Database pages 30038
Old database pages 11108
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 11753523, not young 8817910156
1.85 youngs/s, 2747.22 non-youngs/s
Pages read 58085044, created 993798, written 12296460
63.53 reads/s, 0.00 creates/s, 0.57 writes/s
Buffer pool hit rate 981 / 1000, young-making rate 0 / 1000 not 783 / 1000
Pages read ahead 36.27/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30038, unzip_LRU len: 0
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 32108
Free buffers 968
Database pages 30031
Old database pages 11100
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 12174824, not young 8481095072
6.23 youngs/s, 2664.89 non-youngs/s
Pages read 57165440, created 982520, written 12213809
75.17 reads/s, 0.00 creates/s, 0.02 writes/s
Buffer pool hit rate 978 / 1000, young-making rate 1 / 1000 not 773 / 1000
Pages read ahead 38.40/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30031, unzip_LRU len: 0
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 32108
Free buffers 996
Database pages 30043
Old database pages 11087
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 11524506, not young 8737561103
1.72 youngs/s, 2942.52 non-youngs/s
Pages read 57607543, created 988809, written 12263030
69.20 reads/s, 0.00 creates/s, 1.05 writes/s
Buffer pool hit rate 984 / 1000, young-making rate 0 / 1000 not 674 / 1000
Pages read ahead 41.60/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30043, unzip_LRU len: 1
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 32108
Free buffers 1000
Database pages 30044
Old database pages 11085
Modified db pages 6
Percent of dirty pages(LRU & free pages): 0.019
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11798138, not young 8708132527
1.83 youngs/s, 2958.88 non-youngs/s
Pages read 57759666, created 993417, written 12093038
61.82 reads/s, 0.00 creates/s, 0.45 writes/s
Buffer pool hit rate 983 / 1000, young-making rate 0 / 1000 not 792 / 1000
Pages read ahead 35.18/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30044, unzip_LRU len: 0
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 32108
Free buffers 995
Database pages 30052
Old database pages 11091
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 11657173, not young 8880624029
1.52 youngs/s, 2945.48 non-youngs/s
Pages read 57924977, created 991658, written 11990992
68.40 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 981 / 1000, young-making rate 0 / 1000 not 777 / 1000
Pages read ahead 43.73/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30052, unzip_LRU len: 1
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 32108
Free buffers 941
Database pages 30041
Old database pages 11109
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 12310666, not young 8793953976
6.03 youngs/s, 3265.51 non-youngs/s
Pages read 57983092, created 1015262, written 12099534
84.83 reads/s, 0.00 creates/s, 0.07 writes/s
Buffer pool hit rate 979 / 1000, young-making rate 1 / 1000 not 780 / 1000
Pages read ahead 45.87/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30041, unzip_LRU len: 0
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 32108
Free buffers 958
Database pages 30096
Old database pages 11129
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 11940315, not young 8865176498
1.90 youngs/s, 2980.55 non-youngs/s
Pages read 57878469, created 998865, written 12216210
67.35 reads/s, 0.00 creates/s, 0.05 writes/s
Buffer pool hit rate 982 / 1000, young-making rate 0 / 1000 not 777 / 1000
Pages read ahead 43.73/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 30096, unzip_LRU len: 0
I/O sum[14022]:cur[144], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Process ID=4208, Main thread ID=17144, state: sleeping
Number of rows inserted 447726529, updated 2680, deleted 379539389, read 57030521495
0.00 inserts/s, 1.60 updates/s, 0.00 deletes/s, 56456.59 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 7563
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
