Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2026-10-19 21:38:00 0x459c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 47 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 3137925 srv_active, 0 srv_shutdown, 1862227 srv_idle
srv_master_thread log flush and writes: 4999370
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 236671203
OS WAIT ARRAY INFO: signal count 1182779572
RW-shared spins 1960693566, rounds 10066459569, OS waits 172341361
RW-excl spins 4424114562, rounds 14596698001, OS waits 17152172
RW-sx spins 595633042, rounds 3984266117, OS waits 26560323
Spin rounds per wait: 5.13 RW-shared, 3.30 RW-excl, 6.69 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-09-22 13:28:06 0x2174 Transaction:
TRANSACTION 79855259, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
8 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 1
MySQL thread id 446068, OS thread handle 8564, query id 1369230847 localhost ::1 root Updating
UPDATE `v145`.`characters` SET `id` = '60,120,60,0,0,0,0,0,0,0', `accountid` = '60,120,60,0,0,0,0,0,0,0', `world` = '60,120,60,0,0,0,0,0,0,0', `name` = '60,120,60,0,0,0,0,0,0,0', `level` = '60,120,60,0,0,0,0,0,0,0', `exp` = '60,120,60,0,0,0,0,0,0,0', `str` = '60,120,60,0,0,0,0,0,0,0', `dex` = '60,120,60,0,0,0,0,0,0,0', `luk` = '60,120,60,0,0,0,0,0,0,0', `int` = '60,120,60,0,0,0,0,0,0,0', `hp` = '60,120,60,0,0,0,0,0,0,0', `mp` = '60,120,60,0,0,0,0,0,0,0', `maxhp` = '60,120,60,0,0,0,0,0,0,0', `maxmp` = '60,120,60,0,0,0,0,0,0,0', `meso` = '60,120,60,0,0,0,0,0,0,0', `hpApUsed` = '60,120,60,0,0,0,0
Foreign key constraint fails for table `v145`.`keymap`:
,
  CONSTRAINT `keymap_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
Trying to update in parent table, in index PRIMARY tuple:
DATA TUPLE: 72 fields;
 0: len 4; hex 80001a59; asc    Y;;
 1: len 6; hex 000004c27e9b; asc     ~ ;;
 2: len 7; hex 7b0000016b28f5; asc {   k( ;;
 3: len 4; hex 80000222; asc    ";;
 4: len 1; hex 80; asc  ;;
 5: len 9; hex e883a1e6a492e89da6; asc          ;;
 6: len 4; hex 0000005a; asc    Z;;
 7: len 8; hex 80000000000000d7; asc         ;;
 8: len 4; hex 80000025; asc    %;;
 9: len 4; hex 80000005; asc     ;;
 10: len 4; hex 80000004; asc     ;;
 11: len 4; hex 80000004; asc     ;;
 12: len 4; hex 80000075; asc    u;;
 13: len 4; hex 8000006c; asc    l;;
 14: len 4; hex 80000078; asc    x;;
 15: len 4; hex 8000006c; asc    l;;
 16: len 8; hex 80000000000000dd; asc         ;;
 17: len 4; hex 80000000; asc     ;;
 18: len 4; hex 80000000; asc     ;;
 19: len 1; hex 80; asc  ;;
 20: len 1; hex 81; asc  ;;
 21: len 4; hex 80000000; asc     ;;
 22: len 4; hex 80007951; asc   yQ;;
 23: len 4; hex 800054c4; asc   T ;;
 24: len 4; hex 80000190; asc     ;;
 25: len 4; hex 800f6950; asc   iP;;
 26: len 4; hex 80000000; asc     ;;
 27: len 4; hex 80000000; asc     ;;
 28: len 4; hex 7fffffff; asc     ;;
 29: len 4; hex 80000014; asc     ;;
 30: len 4; hex 6aac2194; asc j ! ;;
 31: len 4; hex 00000000; asc     ;;
 32: len 1; hex 05; asc  ;;
 33: len 4; hex 80000000; asc     ;;
 34: len 1; hex 05; asc  ;;
 35: len 4; hex 00000000; asc     ;;
 36: len 4; hex 00000000; asc     ;;
 37: len 1; hex 00; asc  ;;
 38: len 8; hex 2d312c2d312c2d31; asc -1,-1,-1;;
 39: len 19; hex 302c302c302c302c302c302c302c302c302c30; asc 0,0,0,0,0,0,0,0,0,0;;
 40: len 5; hex 302c302c30; asc 0,0,0;;
 41: len 4; hex 80000001; asc     ;;
 42: len 8; hex 8000000000000000; asc         ;;
 43: len 4; hex 80000001; asc     ;;
 44: len 4; hex 80000000; asc     ;;
 45: len 4; hex 80000001; asc     ;;
 46: len 4; hex 80000000; asc     ;;
 47: len 4; hex 80000000; asc     ;;
 48: len 4; hex 80000000; asc     ;;
 49: len 4; hex 80000000; asc     ;;
 50: len 4; hex 80000000; asc     ;;
 51: len 4; hex 80000000; asc     ;;
 52: len 4; hex 80000000; asc     ;;
 53: len 4; hex 80000000; asc     ;;
 54: len 6; hex e5ae89e5ae89; asc       ;;
 55: len 4; hex 80000000; asc     ;;
 56: len 4; hex 80000000; asc     ;;
 57: len 4; hex 80000000; asc     ;;
 58: len 4; hex 80000000; asc     ;;
 59: len 4; hex 80000000; asc     ;;
 60: len 4; hex 80000000; asc     ;;
 61: len 0; hex ; asc ;;
 62: len 4; hex 80000000; asc     ;;
 63: len 4; hex 80000001; asc     ;;
 64: len 4; hex 80000001; asc     ;;
 65: len 4; hex 80000019; asc     ;;
 66: len 4; hex 80000000; asc     ;;
 67: len 4; hex 00000000; asc     ;;
 68: len 39; hex 302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c30; asc 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;;
 69: len 39; hex 302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c30; asc 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;;
 70: len 39; hex 302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c30; asc 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;;
 71: len 4; hex 80000000; asc     ;;

But in child table `v145`.`keymap`, in index keymap_ibfk_1, there is a record:
PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 80001a59; asc    Y;;
 1: len 8; hex 8000000075563245; asc     uV2E;;

------------
TRANSACTIONS
------------
Trx id counter 143280370
Purge done for trx's n:o < 143280361 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283782208635960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208631792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208669304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208665136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208656800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208640128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208610952, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208594280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208602616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208585944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208581776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208615120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208623456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208619288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208598448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208698480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208702648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208652632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208627624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208648464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208644296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209436216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209452888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209448720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209440384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209432048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209427880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209423712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209419544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209415376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209411208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209407040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209402872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209394536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209390368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209386200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209382032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209377864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209369528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209365360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209361192, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209357024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209352856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209348688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209344520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209340352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209332016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209323680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209319512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209315344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209307008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209298672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209290336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209282000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209277832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209273664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209261160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209256992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209248656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209244488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209240320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209231984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209223648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209219480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209215312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209202808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209194472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209186136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209177800, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209173632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209169464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209161128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209152792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209148624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209140288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209136120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209123616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209119448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209111112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209106944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209102776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209094440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209090272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209081936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209069432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209061096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209052760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209048592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209036088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209031920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209027752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209019416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782209006912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208998576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208994408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208981904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208931888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208798512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208606784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208590112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208723488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283782208710984, 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
1843829836 OS file reads, 1102205024 OS file writes, 184734616 OS fsyncs
693.05 reads/s, 16384 avg bytes/read, 226.82 writes/s, 41.19 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 78, seg size 80, 6988851 merges
merged operations:
 insert 17529217, delete mark 15723853, delete 15006677
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)
1660.56 hash searches/s, 3294.65 non-hash searches/s
---
LOG
---
Log sequence number 3618280895056
Log flushed up to   3618280894756
Pages flushed up to 3618280892226
Last checkpoint at  3618280868706
0 pending log flushes, 0 pending chkp writes
81095178 log i/o's done, 17.11 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 696112
Buffer pool size   1003
Free buffers       739
Database pages     256
Old database pages 0
Modified db pages  15
Percent of dirty pages(LRU & free pages): 1.506
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 89031744, not young 201625511339
22.19 youngs/s, 97778.60 non-youngs/s
Pages read 1843829799, created 178181975, written 997124694
693.07 reads/s, 34.83 creates/s, 204.55 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 182 / 1000
Pages read ahead 189.08/s, evicted without access 3.11/s, Random read ahead 0.00/s
LRU len: 256, unzip_LRU len: 0
I/O sum[33509]:cur[31], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=2904, Main thread ID=7724, state: sleeping
Number of rows inserted 3505957368, updated 102886790, deleted 3494266825, read 786662677846
462.16 inserts/s, 18.87 updates/s, 461.22 deletes/s, 539337.52 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 487237
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================