Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-06-06 07:06:34 0x1e4c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 18 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 414395 srv_active, 0 srv_shutdown, 457912 srv_idle
srv_master_thread log flush and writes: 872297
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 63071890
OS WAIT ARRAY INFO: signal count 38477259
RW-shared spins 36305091, rounds 518742573, OS waits 13141893
RW-excl spins 10019475, rounds 78492161, OS waits 1409035
RW-sx spins 2025008, rounds 43049640, OS waits 1132803
Spin rounds per wait: 14.29 RW-shared, 7.83 RW-excl, 21.26 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 5929168
Purge done for trx's n:o < 5929161 undo n:o < 0 state: running but idle
History list length 24
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284334407295336, 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 284334407299504, ACTIVE 1 sec
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 294435, OS thread handle 13928, query id 49138905 localhost 127.0.0.1 root Writing to net
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 >= 5929160, sees < 5929160
---TRANSACTION 284334407291168, ACTIVE 1 sec
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 294434, OS thread handle 17076, query id 49138886 localhost 127.0.0.1 root 
Trx read view will not see trx with id >= 5929158, sees < 5929158
---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
3675249078 OS file reads, 96754035 OS file writes, 12755704 OS fsyncs
12217.10 reads/s, 16384 avg bytes/read, 201.16 writes/s, 27.78 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 405, seg size 407, 2029414 merges
merged operations:
 insert 1690472, delete mark 15316506, delete 9224771
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 22 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)
1317.98 hash searches/s, 28550.97 non-hash searches/s
---
LOG
---
Log sequence number 115516128506
Log flushed up to   115516128506
Pages flushed up to 115516128506
Last checkpoint at  115516075930
0 pending log flushes, 0 pending chkp writes
1997223 log i/o's done, 4.28 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     973
Old database pages 366
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 11980614, not young 28887408898
16.00 youngs/s, 73790.51 non-youngs/s
Pages read 3675249009, created 773192, written 89193999
12217.10 reads/s, 2.78 creates/s, 184.77 writes/s
Buffer pool hit rate 904 / 1000, young-making rate 0 / 1000 not 575 / 1000
Pages read ahead 143.44/s, evicted without access 22.39/s, Random read ahead 0.00/s
LRU len: 973, unzip_LRU len: 0
I/O sum[503701]:cur[16840], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Process ID=4028, Main thread ID=5520, state: sleeping
Number of rows inserted 179876, updated 13848046, deleted 20281, read 10469746236
0.17 inserts/s, 36.44 updates/s, 0.00 deletes/s, 27093.77 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
============================