Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-06-06 04:16:53 0x3e84 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 44 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 407851 srv_active, 0 srv_shutdown, 454330 srv_idle
srv_master_thread log flush and writes: 862171
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 61115494
OS WAIT ARRAY INFO: signal count 37126782
RW-shared spins 34468482, rounds 490930600, OS waits 12412257
RW-excl spins 9593047, rounds 74465162, OS waits 1326443
RW-sx spins 1974321, rounds 42133869, OS waits 1110742
Spin rounds per wait: 14.24 RW-shared, 7.76 RW-excl, 21.34 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2026-05-27 05:07:02 0x3828
*** (1) TRANSACTION:
TRANSACTION 4419575, ACTIVE 2 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1128, 34 row lock(s), undo log entries 16
MySQL thread id 44, OS thread handle 13896, query id 116783 localhost 127.0.0.1 root Update
INSERT INTO `pg_tracking` (
        currency, brand, report_type, reference, channel, pg_chart_id, pg_processing_time, pg_completed_time, pg_status,
        payment_chart_id, pyt_processing_time, pyt_completed_time, pyt_status, error_note, pg_amount,
        pg_pic_primary, pg_pic_secondary, pg_speed_seconds, pyt_speed_seconds, total_speed_seconds, record_date, pg_pic
    ) VALUES (
        'BDT', 'JEETBANGLA', 'error_pending', '75C7N5G3', 'SmartPay', '', NULL, NULL, 'CS - kindly ask player raised correct reference again .', '', NULL, NULL, '', '', NULL, 'BAyman', '', NULL, NULL, NULL, '2026-05-11', 'BAyman'
    ),(
        'BDT', 'JEETBANGLA', 'error_pending', 'DEK1F9O1MP', 'SmartPay', '', NULL, NULL, 'CS - kindly ask player raised correct reference again .', '', NULL, NULL, '', '', NULL, 'SLYumi', '', NULL, NULL, NULL, '2026-05-20', 'SLYumi'
    ),(
        'BDT', 'JEETBANGLA', 'error_pending', 'DEK5FC1269', 'SmartP
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 82 page no 71965 n bits 168 index PRIMARY of table `pg_dashboard`.`pg_tracking` trx id 4419575 lock_mode X locks rec but not gap waiting
Record lock, heap no 42
*** (2) TRANSACTION:
TRANSACTION 4419535, ACTIVE 21 sec fetching rows
mysql tables in use 1, locked 1
8802 lock struct(s), heap size 991352, 609262 row lock(s), undo log entries 53255
MySQL thread id 2251, OS thread handle 14376, query id 116699 localhost 127.0.0.1 root Updating
UPDATE pg_tracking SET pg_pic = CASE pg_pic_override WHEN 'BVLICHA' THEN 'LICHA' WHEN 'BVHNA' THEN 'HENA' WHEN 'BVYUTH' THEN 'YUTH' WHEN 'BVKAKA' THEN 'KAKA' WHEN 'BVLINLIN' THEN 'LIN LIN' WHEN 'BVKHY' THEN 'KHY' WHEN 'BVVD' THEN 'VD' WHEN 'BVFOU' THEN 'FOU' WHEN 'BVKIMLY' THEN 'KIM LYY' WHEN 'BVJEN' THEN 'JEN' ELSE pg_pic END, pg_pic_override = '' WHERE currency='BDT' AND report_type='main' AND record_date BETWEEN '2026-01-01' AND '2026-12-31' AND pg_pic_override IN ('BVLICHA','BVHNA','BVYUTH','BVKAKA','BVLINLIN','BVKHY','BVVD','BVFOU','BVKIMLY','BVJEN')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 82 page no 71965 n bits 168 index PRIMARY of table `pg_dashboard`.`pg_tracking` trx id 4419535 lock_mode X
Record lock, heap no 1
Record lock, heap no 3
Record lock, heap no 4
Record lock, heap no 7
Record lock, heap no 10
Record lock, heap no 12
Record lock, heap no 14
Record lock, heap no 15
Record lock, heap no 16
Record lock, heap no 17
Record lock, heap no 19
Record lock, heap no 20
Record lock, heap no 21
Record lock, heap no 23
Record lock, heap no 26
Record lock, heap no 27
Record lock, heap no 29
Record lock, heap no 30
Record lock, heap no 32
Record lock, heap no 35
Record lock, heap no 36
Record lock, heap no 37
Record lock, heap no 38
Record lock, heap no 42
Record lock, heap no 44
Record lock, heap no 45
Record lock, heap no 47
Record lock, heap no 51
Record lock, heap no 52
Record lock, heap no 53
Record lock, heap no 55
Record lock, heap no 72
Record lock, heap no 75
Record lock, heap no 76
Record lock, heap no 77
Record lock, heap no 79
Record lock, heap no 80
Record lock, heap no 83
Record lock, heap no 84
Record lock, heap no 86
Record lock, heap no 91
Record lock, heap no 92
Record lock, heap no 93
Record lock, heap no 94
Record lock, heap no 95
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 82 page no 55465 n bits 136 index PRIMARY of table `pg_dashboard`.`pg_tracking` trx id 4419535 lock_mode X waiting
Record lock, heap no 24 PHYSICAL RECORD: n_fields 28; compact format; info bits 0
 0: len 8; hex 0000000002da6388; asc       c ;;
 1: len 6; hex 000000436ff7; asc    Co ;;
 2: len 7; hex 00000007c70110; asc        ;;
 3: len 10; hex 4a45455442414e474c41; asc JEETBANGLA;;
 4: len 3; hex 424454; asc BDT;;
 5: len 13; hex 6572726f725f70656e64696e67; asc error_pending;;
 6: len 8; hex 373543374e354733; asc 75C7N5G3;;
 7: len 8; hex 536d617274506179; asc SmartPay;;
 8: len 0; hex ; asc ;;
 9: SQL NULL;
 10: SQL NULL;
 11: len 30; hex 4353202d206b696e646c792061736b20706c617965722072616973656420; asc CS - kindly ask player raised ; (total 55 bytes);
 12: len 0; hex ; asc ;;
 13: SQL NULL;
 14: SQL NULL;
 15: len 0; hex ; asc ;;
 16: len 0; hex ; asc ;;
 17: SQL NULL;
 18: len 6; hex 4241796d616e; asc BAyman;;
 19: len 0; hex ; asc ;;
 20: len 0; hex ; asc ;;
 21: SQL NULL;
 22: SQL NULL;
 23: SQL NULL;
 24: len 3; hex 8fd4ab; asc    ;;
 25: len 6; hex 4241796d616e; asc BAyman;;
 26: len 4; hex 6a0fae96; asc j   ;;
 27: len 4; hex 6a161984; asc j   ;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 5882728
Purge done for trx's n:o < 5882643 undo n:o < 0 state: running but idle
History list length 41
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284334407312008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334407299504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334407291168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334407282832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334407307840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334407303672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284334407295336, ACTIVE 8 sec
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 264343, OS thread handle 1960, query id 48401833 localhost 127.0.0.1 root 
Trx read view will not see trx with id >= 5882643, sees < 5882642
---TRANSACTION 284334407287000, 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
3568224142 OS file reads, 95043138 OS file writes, 12573934 OS fsyncs
10513.15 reads/s, 16384 avg bytes/read, 149.68 writes/s, 18.75 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 1980478 merges
merged operations:
 insert 1674426, delete mark 14171398, delete 8847382
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 39 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
11791.00 hash searches/s, 30861.14 non-hash searches/s
---
LOG
---
Log sequence number 114586533161
Log flushed up to   114586533161
Pages flushed up to 114586529011
Last checkpoint at  114586491101
0 pending log flushes, 0 pending chkp writes
1958512 log i/o's done, 4.70 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 167768
Buffer pool size   1003
Free buffers       1
Database pages     956
Old database pages 371
Modified db pages  7
Percent of dirty pages(LRU & free pages): 0.731
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11893195, not young 27947008562
22.74 youngs/s, 225437.39 non-youngs/s
Pages read 3568224073, created 751117, written 87595947
9551.61 reads/s, 1.00 creates/s, 16.25 writes/s
Buffer pool hit rate 972 / 1000, young-making rate 0 / 1000 not 652 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 956, unzip_LRU len: 0
I/O sum[556040]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=4028, Main thread ID=5520, state: sleeping
Number of rows inserted 179445, updated 13518132, deleted 20235, read 10128247115
0.05 inserts/s, 27.32 updates/s, 0.00 deletes/s, 40586.80 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 18165
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================