Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-10-27 06:13:48 0x16bc INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 57 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 2470762 srv_active, 0 srv_shutdown, 1104131 srv_idle
srv_master_thread log flush and writes: 3574893
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 30393933
OS WAIT ARRAY INFO: signal count 14419360
RW-shared spins 7963466, rounds 68122711, OS waits 1974281
RW-excl spins 9161707, rounds 41644246, OS waits 138836
RW-sx spins 236572, rounds 2246334, OS waits 21143
Spin rounds per wait: 8.55 RW-shared, 4.55 RW-excl, 9.50 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2026-10-27 01:49:25 0x10bc
*** (1) TRANSACTION:
TRANSACTION 3614354724, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1
MySQL thread id 17018616, OS thread handle 15764, query id 41511120675 localhost 127.0.0.1 root Update
INSERT INTO transaction_logs (transaction_id, sheet_name, sheet_row, agent_number, player_number, amount, pic_name, reason, status_label, image_link, processing_seconds, source_type, status, logged_at)
             VALUES ('767F0ZAR', 'MVB-sheet', '645', '1947117994', '1577194580', '', '', 'Agent No Response', NULL, 'https://download.v2ply.com/bdt/BJLBDT/767F0ZAR_Screenshot_20261027_142210_Nagad.png', '1534', '', 'PROVIDE_VIDEO', '2026-10-27T08:49:25+00:00')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 193 page no 384 n bits 392 index idx_transaction_logs_status_logged of table `dashboard_agent`.`transaction_logs` trx id 3614354724 lock_mode X insert intention waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;

*** (2) TRANSACTION:
TRANSACTION 3614354723, ACTIVE 0 sec fetching rows
mysql tables in use 2, locked 2
231 lock struct(s), heap size 41080, 12088 row lock(s), undo log entries 1
MySQL thread id 17018655, OS thread handle 4284, query id 41511120665 localhost 127.0.0.1 root Sending data
DELETE FROM transaction_logs
                 WHERE id IN (
                   SELECT id FROM (
                     SELECT id
                     FROM transaction_logs
                     WHERE status = 'RECEIVED'
        AND (source_type IS NULL OR source_type = '' OR source_type <> 'sheet_completed_sync')
        AND (
            (TRIM(COALESCE(status_label, '')) = ''
             AND LOWER(TRIM(COALESCE(reason, ''))) NOT IN ('success', 'auto', 'make up'))
            OR LOWER(TRIM(COALESCE(NULLIF(status_label, ''), reason, ''))) IN ('success', 'auto', 'make up')
        )
                     ORDER BY logged_at ASC, id ASC
                     LIMIT 1
                   ) old_completed_reports
                 )
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 193 page no 384 n bits 392 index idx_transaction_logs_status_logged of table `dashboard_agent`.`transaction_logs` trx id 3614354723 lock mode S
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 193 page no 184 n bits 120 index PRIMARY of table `dashboard_agent`.`transaction_logs` trx id 3614354723 lock_mode X waiting
Record lock, heap no 49 PHYSICAL RECORD: n_fields 17; compact format; info bits 0
 0: len 4; hex 8002be76; asc    v;;
 1: len 6; hex 0000d76ead24; asc    n $;;
 2: len 7; hex e7000001992f3c; asc      /<;;
 3: len 8; hex 37363746305a4152; asc 767F0ZAR;;
 4: len 9; hex 4d56422d7368656574; asc MVB-sheet;;
 5: len 4; hex 80000285; asc     ;;
 6: len 10; hex 31393437313137393934; asc 1947117994;;
 7: len 10; hex 31353737313934353830; asc 1577194580;;
 8: len 0; hex ; asc ;;
 9: len 17; hex 4167656e74204e6f20526573706f6e7365; asc Agent No Response;;
 10: len 30; hex 68747470733a2f2f646f776e6c6f61642e7632706c792e636f6d2f626474; asc https://download.v2ply.com/bdt; (total 83 bytes);
 11: len 4; hex 800005fe; asc     ;;
 12: len 13; hex 50524f564944455f564944454f; asc PROVIDE_VIDEO;;
 13: len 25; hex 323032362d31302d32375430383a34393a32352b30303a3030; asc 2026-10-27T08:49:25+00:00;;
 14: len 0; hex ; asc ;;
 15: SQL NULL;
 16: len 0; hex ; asc ;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 3615268611
Purge done for trx's n:o < 3615268600 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283707187417376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707187413208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707187421544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 3615268610, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 1
89 lock struct(s), heap size 24696, 4668 row lock(s)
MySQL thread id 17104689, OS thread handle 15764, query id 41755151758 localhost 127.0.0.1 root Updating
UPDATE transaction_logs
             SET status = 'RECEIVED', status_label = 'Success', logged_at = '2026-10-27T13:13:48+00:00'
             WHERE sheet_name = 'CX Sheet'
               AND sheet_row = '822'
               AND status IN ('RECEIVED', 'NOT_RECEIVED', 'PROVIDE_VIDEO')
                AND (status_label IS NULL OR TRIM(status_label) = '' OR status_label <> 'Success')
--------
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
2593 OS file reads, 121375719 OS file writes, 37431646 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 31.51 writes/s, 8.35 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 9, seg size 11, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 17700857, node heap has 12 buffer(s)
Hash table size 17700857, node heap has 58 buffer(s)
Hash table size 17700857, node heap has 1 buffer(s)
Hash table size 17700857, node heap has 13 buffer(s)
Hash table size 17700857, node heap has 28 buffer(s)
Hash table size 17700857, node heap has 10 buffer(s)
Hash table size 17700857, node heap has 66 buffer(s)
Hash table size 17700857, node heap has 185 buffer(s)
38833.48 hash searches/s, 48324.73 non-hash searches/s
---
LOG
---
Log sequence number 96708145250
Log flushed up to   96708095511
Pages flushed up to 96708019558
Last checkpoint at  96708019558
0 pending log flushes, 0 pending chkp writes
27258042 log i/o's done, 8.51 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 69256347648
Dictionary memory allocated 305488
Buffer pool size   4109824
Free buffers       4099767
Database pages     9683
Old database pages 3412
Modified db pages  248
Percent of dirty pages(LRU & free pages): 0.006
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 48, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2469, created 7214, written 81041742
0.00 reads/s, 0.00 creates/s, 20.23 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 9683, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   513728
Free buffers       512500
Database pages     1188
Old database pages 418
Modified db pages  11
Percent of dirty pages(LRU & free pages): 0.002
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 381, created 807, written 6256636
0.00 reads/s, 0.00 creates/s, 1.07 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1188, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   513728
Free buffers       512542
Database pages     1142
Old database pages 401
Modified db pages  30
Percent of dirty pages(LRU & free pages): 0.006
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 15, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 365, created 777, written 7613161
0.00 reads/s, 0.00 creates/s, 2.82 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1142, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   513728
Free buffers       512525
Database pages     1152
Old database pages 405
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 25, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 334, created 818, written 1390445
0.00 reads/s, 0.00 creates/s, 0.26 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1152, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   513728
Free buffers       512487
Database pages     1182
Old database pages 416
Modified db pages  92
Percent of dirty pages(LRU & free pages): 0.018
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 269, created 913, written 18951860
0.00 reads/s, 0.00 creates/s, 5.93 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1182, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   513728
Free buffers       512379
Database pages     1297
Old database pages 459
Modified db pages  55
Percent of dirty pages(LRU & free pages): 0.011
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 241, created 1056, written 23689859
0.00 reads/s, 0.00 creates/s, 4.65 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1297, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   513728
Free buffers       512292
Database pages     1394
Old database pages 494
Modified db pages  19
Percent of dirty pages(LRU & free pages): 0.004
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 337, created 1057, written 9668441
0.00 reads/s, 0.00 creates/s, 2.54 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1394, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   513728
Free buffers       512470
Database pages     1214
Old database pages 428
Modified db pages  24
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 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 299, created 915, written 10956479
0.00 reads/s, 0.00 creates/s, 2.23 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1214, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   513728
Free buffers       512572
Database pages     1114
Old database pages 391
Modified db pages  17
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 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 243, created 871, written 2514861
0.00 reads/s, 0.00 creates/s, 0.72 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1114, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=4424, Main thread ID=7888, state: sleeping
Number of rows inserted 4104573, updated 14634347, deleted 3809330, read 1070518755300
1.07 inserts/s, 5.67 updates/s, 0.74 deletes/s, 547024.18 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 6852
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================