Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-08-09 04:52:44 0x3e30 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 15 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 64854 srv_active, 0 srv_shutdown, 242979 srv_idle
srv_master_thread log flush and writes: 307830
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1070760
OS WAIT ARRAY INFO: signal count 546259
RW-shared spins 1962482, rounds 36397498, OS waits 365755
RW-excl spins 338628, rounds 1580987, OS waits 25385
RW-sx spins 20488, rounds 379407, OS waits 11119
Spin rounds per wait: 18.55 RW-shared, 4.67 RW-excl, 18.52 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2026-08-06 17:38:18 0x207c
*** (1) TRANSACTION:
TRANSACTION 43576346, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1128, 6 row lock(s)
MySQL thread id 50038, OS thread handle 7780, query id 4021020 localhost 127.0.0.1 isp_apps Searching rows for update
UPDATE employee_duty_sessions SET ended_at=CONCAT(duty_date," 23:59:59"), status="ended" WHERE status="on_duty" AND duty_date < CURDATE()
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 446 page no 10 n bits 104 index PRIMARY of table `isp_stock_management`.`employee_duty_sessions` trx id 43576346 lock_mode X locks rec but not gap waiting
Record lock, heap no 35 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
 0: len 8; hex 00000000000000a6; asc         ;;
 1: len 6; hex 00000298ec19; asc       ;;
 2: len 7; hex 71000003f804a8; asc q      ;;
 3: len 8; hex 0000000000000010; asc         ;;
 4: len 3; hex 8fd506; asc    ;;
 5: len 5; hex 99ba8c999b; asc      ;;
 6: len 5; hex 99ba8d1992; asc      ;;
 7: len 6; hex 801200466105; asc    Fa ;;
 8: len 6; hex 8049007ba4eb; asc  I {  ;;
 9: len 6; hex 80120046611a; asc    Fa ;;
 10: len 6; hex 8049007ba520; asc  I {  ;;
 11: len 5; hex 8000001400; asc      ;;
 12: len 5; hex 8000001400; asc      ;;
 13: len 1; hex 02; asc  ;;
 14: len 30; hex 4d6f7a696c6c612f352e3020284c696e75783b20416e64726f6964203134; asc Mozilla/5.0 (Linux; Android 14; (total 161 bytes);
 15: len 14; hex 3137322e37312e3139382e313531; asc 172.71.198.151;;
 16: len 4; hex 6a7408bb; asc jt  ;;
 17: len 4; hex 6a747932; asc jty2;;
 18: len 30; hex 75706c6f6164732f647574795f73656c666965732f32303236303830362f; asc uploads/duty_selfies/20260806/; (total 57 bytes);
 19: len 28; hex 6572706465762d313738353437393835383334332d31663764646235; asc erpdev-1785479858343-1f7ddb5;;
 20: len 28; hex 6572706465762d313738353437393835383334332d31663764646235; asc erpdev-1785479858343-1f7ddb5;;
 21: len 4; hex 5a616c61; asc Zala;;
 22: len 30; hex 75706c6f6164732f647574795f73656c666965732f32303236303830362f; asc uploads/duty_selfies/20260806/; (total 61 bytes);
 23: SQL NULL;
 24: SQL NULL;
 25: SQL NULL;
 26: SQL NULL;

*** (2) TRANSACTION:
TRANSACTION 43576345, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1
MySQL thread id 50037, OS thread handle 8316, query id 4021026 localhost 127.0.0.1 isp_apps Updating
UPDATE employee_duty_sessions SET ended_at=NOW(),end_lat=?,end_lng=?,end_accuracy=?,end_device_id=?,pending_task_end_reason=?,end_selfie_path=?,end_meter_reading=?,end_meter_photo_path=?,status="ended" WHERE id=?
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 446 page no 10 n bits 104 index PRIMARY of table `isp_stock_management`.`employee_duty_sessions` trx id 43576345 lock_mode X locks rec but not gap
Record lock, heap no 35 PHYSICAL RECORD: n_fields 27; compact format; info bits 0
 0: len 8; hex 00000000000000a6; asc         ;;
 1: len 6; hex 00000298ec19; asc       ;;
 2: len 7; hex 71000003f804a8; asc q      ;;
 3: len 8; hex 0000000000000010; asc         ;;
 4: len 3; hex 8fd506; asc    ;;
 5: len 5; hex 99ba8c999b; asc      ;;
 6: len 5; hex 99ba8d1992; asc      ;;
 7: len 6; hex 801200466105; asc    Fa ;;
 8: len 6; hex 8049007ba4eb; asc  I {  ;;
 9: len 6; hex 80120046611a; asc    Fa ;;
 10: len 6; hex 8049007ba520; asc  I {  ;;
 11: len 5; hex 8000001400; asc      ;;
 12: len 5; hex 8000001400; asc      ;;
 13: len 1; hex 02; asc  ;;
 14: len 30; hex 4d6f7a696c6c612f352e3020284c696e75783b20416e64726f6964203134; asc Mozilla/5.0 (Linux; Android 14; (total 161 bytes);
 15: len 14; hex 3137322e37312e3139382e313531; asc 172.71.198.151;;
 16: len 4; hex 6a7408bb; asc jt  ;;
 17: len 4; hex 6a747932; asc jty2;;
 18: len 30; hex 75706c6f6164732f647574795f73656c666965732f32303236303830362f; asc uploads/duty_selfies/20260806/; (total 57 bytes);
 19: len 28; hex 6572706465762d313738353437393835383334332d31663764646235; asc erpdev-1785479858343-1f7ddb5;;
 20: len 28; hex 6572706465762d313738353437393835383334332d31663764646235; asc erpdev-1785479858343-1f7ddb5;;
 21: len 4; hex 5a616c61; asc Zala;;
 22: len 30; hex 75706c6f6164732f647574795f73656c666965732f32303236303830362f; asc uploads/duty_selfies/20260806/; (total 61 bytes);
 23: SQL NULL;
 24: SQL NULL;
 25: SQL NULL;
 26: SQL NULL;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 446 page no 5 n bits 264 index idx_duty_status of table `isp_stock_management`.`employee_duty_sessions` trx id 43576345 lock_mode X locks rec but not gap waiting
Record lock, heap no 158 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 1; hex 01; asc  ;;
 1: len 8; hex 00000000000000a6; asc         ;;

*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 43925708
Purge done for trx's n:o < 43925708 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283685361209560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283685361205392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283685361230400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283685361213728, not started flushing log
mysql tables in use 1, locked 1
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283685361222064, 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: 1; buffer pool: 0
6032747 OS file reads, 1535977 OS file writes, 670684 OS fsyncs
4.47 reads/s, 16384 avg bytes/read, 5.80 writes/s, 3.07 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 119, seg size 121, 21032 merges
merged operations:
 insert 306673, delete mark 213929, delete 2310
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 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)
Hash table size 4441, node heap has 1 buffer(s)
4.93 hash searches/s, 16.40 non-hash searches/s
---
LOG
---
Log sequence number 13428423878
Log flushed up to   13428422798
Pages flushed up to 13428421746
Last checkpoint at  13428412798
1 pending log flushes, 0 pending chkp writes
424116 log i/o's done, 2.07 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 368088
Buffer pool size   1003
Free buffers       732
Database pages     263
Old database pages 0
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.502
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 165532, not young 176082282
0.00 youngs/s, 0.00 non-youngs/s
Pages read 6032596, created 24368, written 1025515
4.47 reads/s, 0.00 creates/s, 3.40 writes/s
Buffer pool hit rate 912 / 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: 263, unzip_LRU len: 0
I/O sum[460]:cur[41], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=18344, Main thread ID=12568, state: sleeping
Number of rows inserted 999476, updated 133098, deleted 173283, read 792232010
0.00 inserts/s, 1.00 updates/s, 0.00 deletes/s, 5.93 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 5769
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================