Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-06-06 05:52:43 0x3ec4 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 9 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 411419 srv_active, 0 srv_shutdown, 456471 srv_idle
srv_master_thread log flush and writes: 867880
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 62307734
OS WAIT ARRAY INFO: signal count 37956171
RW-shared spins 35615491, rounds 508992956, OS waits 12886414
RW-excl spins 9845072, rounds 76780410, OS waits 1373731
RW-sx spins 2005886, rounds 42691204, OS waits 1124129
Spin rounds per wait: 14.29 RW-shared, 7.80 RW-excl, 21.28 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 5910103
Purge done for trx's n:o < 5910089 undo n:o < 0 state: running but idle
History list length 11
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 284334407295336, ACTIVE 3 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 281434, OS thread handle 17484, query id 48835398 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 >= 5910088, sees < 5910088
---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
3630802448 OS file reads, 96052609 OS file writes, 12679156 OS fsyncs
1 pending reads, 0 pending writes
10974.67 reads/s, 16384 avg bytes/read, 81.21 writes/s, 8.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 2009537 merges
merged operations:
 insert 1684946, delete mark 14845487, delete 9078788
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 36 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)
4591.93 hash searches/s, 31592.16 non-hash searches/s
---
LOG
---
Log sequence number 115136208054
Log flushed up to   115136208054
Pages flushed up to 115136206613
Last checkpoint at  115135881266
0 pending log flushes, 0 pending chkp writes
1981237 log i/o's done, 2.89 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 167768
Buffer pool size   1003
Free buffers       0
Database pages     960
Old database pages 373
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.520
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11943807, not young 28510621225
8.00 youngs/s, 90075.88 non-youngs/s
Pages read 3630802378, created 763776, written 88539841
10974.56 reads/s, 1.00 creates/s, 75.77 writes/s
Buffer pool hit rate 926 / 1000, young-making rate 0 / 1000 not 600 / 1000
Pages read ahead 64.44/s, evicted without access 9.11/s, Random read ahead 0.00/s
LRU len: 960, unzip_LRU len: 0
I/O sum[529843]:cur[11991], 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 179717, updated 13714480, deleted 20279, read 10333490084
0.00 inserts/s, 19.78 updates/s, 0.00 deletes/s, 34849.35 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 19575
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================