Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-06-06 05:26:37 0x2fd4 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 43 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 410450 srv_active, 0 srv_shutdown, 455882 srv_idle
srv_master_thread log flush and writes: 866322
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 61994153
OS WAIT ARRAY INFO: signal count 37744052
RW-shared spins 35330729, rounds 504526284, OS waits 12767646
RW-excl spins 9779876, rounds 76169219, OS waits 1361205
RW-sx spins 1997664, rounds 42541642, OS waits 1120574
Spin rounds per wait: 14.28 RW-shared, 7.79 RW-excl, 21.30 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 5902955
Purge done for trx's n:o < 5902949 undo n:o < 0 state: running but idle
History list length 5
LIST OF TRANSACTIONS FOR EACH SESSION:
---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 284334407303672, ACTIVE 2 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 276962, OS thread handle 15772, query id 48694959 localhost 127.0.0.1 root Sending data
SELECT
            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, record_date, pg_pic,
            pg_pic_primary, pg_pic_secondary, error_note, pg_amount
        FROM `pg_tracking`
        WHERE currency = 'BDT' AND report_type = 'main' AND brand = 'CX'
Trx read view will not see trx with id >= 5902949, sees < 5902948
---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
3614208862 OS file reads, 95783006 OS file writes, 12650260 OS fsyncs
11974.44 reads/s, 16384 avg bytes/read, 202.46 writes/s, 18.07 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 2001450 merges
merged operations:
 insert 1682081, delete mark 14660325, delete 9021297
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 60 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)
3572.75 hash searches/s, 30721.66 non-hash searches/s
---
LOG
---
Log sequence number 114993364140
Log flushed up to   114993364140
Pages flushed up to 114993364140
Last checkpoint at  114993364060
0 pending log flushes, 0 pending chkp writes
1975186 log i/o's done, 4.65 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     935
Old database pages 330
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 11930336, not young 28366284844
13.19 youngs/s, 88590.45 non-youngs/s
Pages read 3614208793, created 760384, written 88288119
11974.44 reads/s, 2.40 creates/s, 190.81 writes/s
Buffer pool hit rate 918 / 1000, young-making rate 0 / 1000 not 605 / 1000
Pages read ahead 243.55/s, evicted without access 23.19/s, Random read ahead 0.00/s
LRU len: 935, unzip_LRU len: 0
I/O sum[549067]:cur[5956], 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 179626, updated 13663035, deleted 20235, read 10279707311
0.02 inserts/s, 39.49 updates/s, 0.00 deletes/s, 48872.35 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 19465
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================