存储引擎

InnoDB

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

[ 变量 | 缓冲池 | InnoDB 状态 ]

=====================================
2025-07-19 08:40:40 0x1e04 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 30286 srv_active, 0 srv_shutdown, 56670 srv_idle
srv_master_thread log flush and writes: 86956
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 18144
OS WAIT ARRAY INFO: signal count 23542
RW-shared spins 26432, rounds 467194, OS waits 14407
RW-excl spins 14760, rounds 57575, OS waits 530
RW-sx spins 250, rounds 7108, OS waits 182
Spin rounds per wait: 17.68 RW-shared, 3.90 RW-excl, 28.43 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-07-18 20:41:16 0x2a18 Transaction:
TRANSACTION 238742, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1
MySQL thread id 123608, OS thread handle 10776, query id 4384902 192.168.2.223 root Update
insert into penilaian_awal_keperawatan_ranap_rencana values('2025/07/18/000153','001')
Foreign key constraint fails for table `mesrabaru`.`penilaian_awal_keperawatan_ranap_rencana`:
,
  CONSTRAINT `penilaian_awal_keperawatan_ranap_rencana_ibfk_2` FOREIGN KEY (`kode_rencana`) REFERENCES `master_rencana_keperawatan` (`kode_rencana`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index kode_rencana tuple:
DATA TUPLE: 2 fields;
 0: len 3; hex 303031; asc 001;;
 1: len 17; hex 323032352f30372f31382f303030313533; asc 2025/07/18/000153;;

But in parent table `mesrabaru`.`master_rencana_keperawatan`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 0: len 3; hex 303033; asc 003;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 3; hex 303031; asc 001;;
 4: len 25; hex 616e6a75726b616e2074656b6e696b2072656c616b73617369; asc anjurkan teknik relaksasi;;

------------
TRANSACTIONS
------------
Trx id counter 250681
Purge done for trx's n:o < 250681 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283912661621352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661617184, ACTIVE 0 sec
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 1305134, OS thread handle 6700, query id 5775911 localhost ::1 root Creating sort index
SELECT noantrian FROM mlite_antrian_loket WHERE type = 'Loket' AND postdate = '2025-07-19' ORDER BY start_time DESC
Trx read view will not see trx with id >= 250681, sees < 250681
---TRANSACTION 283912661608848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661537992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661604680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661596344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661492144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661592176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661588008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661583840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661563000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661579672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661575504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661571336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661567168, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661500480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661558832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661546328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661521320, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661479640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661475472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661554664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661542160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661496312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661529656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661483808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661517152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661512984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661525488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661550496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661504648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661508816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661487976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661600512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661613016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283912661533824, 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
302680 OS file reads, 246696 OS file writes, 161859 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.12 writes/s, 1.12 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 11, seg size 13, 9796 merges
merged operations:
 insert 11810, delete mark 1395, delete 968
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 326 buffer(s)
Hash table size 1106407, node heap has 13 buffer(s)
Hash table size 1106407, node heap has 58 buffer(s)
Hash table size 1106407, node heap has 871 buffer(s)
Hash table size 1106407, node heap has 244 buffer(s)
Hash table size 1106407, node heap has 12 buffer(s)
Hash table size 1106407, node heap has 108 buffer(s)
Hash table size 1106407, node heap has 109 buffer(s)
23327.71 hash searches/s, 420.95 non-hash searches/s
---
LOG
---
Log sequence number 19733529257
Log flushed up to   19733529257
Pages flushed up to 19733529257
Last checkpoint at  19733529248
0 pending log flushes, 0 pending chkp writes
46912 log i/o's done, 0.62 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 5764208
Buffer pool size   256864
Free buffers       8192
Database pages     246931
Old database pages 90990
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 10543, not young 2304982
0.00 youngs/s, 0.00 non-youngs/s
Pages read 300372, created 1157, written 158132
0.00 reads/s, 0.00 creates/s, 0.25 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: 246931, unzip_LRU len: 0
I/O sum[408]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32108
Free buffers       1024
Database pages     30884
Old database pages 11380
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 1308, not young 177695
0.00 youngs/s, 0.00 non-youngs/s
Pages read 36269, created 92, written 21782
0.00 reads/s, 0.00 creates/s, 0.00 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: 30884, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       1024
Database pages     30875
Old database pages 11377
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 1294, not young 268816
0.00 youngs/s, 0.00 non-youngs/s
Pages read 36454, created 67, written 15073
0.00 reads/s, 0.00 creates/s, 0.00 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: 30875, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       1024
Database pages     30869
Old database pages 11375
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 1386, not young 388625
0.00 youngs/s, 0.00 non-youngs/s
Pages read 39493, created 189, written 18832
0.00 reads/s, 0.00 creates/s, 0.00 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: 30869, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       1024
Database pages     30861
Old database pages 11372
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 1282, not young 312191
0.00 youngs/s, 0.00 non-youngs/s
Pages read 36985, created 135, written 25739
0.00 reads/s, 0.00 creates/s, 0.00 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: 30861, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       1024
Database pages     30878
Old database pages 11378
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 1232, not young 275775
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37644, created 224, written 28061
0.00 reads/s, 0.00 creates/s, 0.12 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: 30878, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       1024
Database pages     30856
Old database pages 11370
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 1330, not young 289675
0.00 youngs/s, 0.00 non-youngs/s
Pages read 38311, created 125, written 18394
0.00 reads/s, 0.00 creates/s, 0.00 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: 30856, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32108
Free buffers       1024
Database pages     30863
Old database pages 11372
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 1390, not young 335358
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37745, created 169, written 16672
0.00 reads/s, 0.00 creates/s, 0.00 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: 30863, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32108
Free buffers       1024
Database pages     30845
Old database pages 11366
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 1321, not young 256847
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37471, created 156, written 13579
0.00 reads/s, 0.00 creates/s, 0.12 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: 30845, unzip_LRU len: 0
I/O sum[51]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=8504, Main thread ID=1668, state: sleeping
Number of rows inserted 33944, updated 4209, deleted 2911, read 5247112689
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 104742.66 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================