将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

存储引擎

InnoDB 文档

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

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


=====================================
2025-07-02 21:36:20 0x2db0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 4 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 16699 srv_active, 0 srv_shutdown, 31387 srv_idle
srv_master_thread log flush and writes: 48086
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 77688
OS WAIT ARRAY INFO: signal count 64441
RW-shared spins 117978, rounds 526555, OS waits 12357
RW-excl spins 19181, rounds 149372, OS waits 2815
RW-sx spins 277, rounds 5026, OS waits 132
Spin rounds per wait: 4.46 RW-shared, 7.79 RW-excl, 18.14 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-07-02 17:09:08 0x1434 Transaction:
TRANSACTION 3793241, 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 8463, OS thread handle 5172, query id 3938542 DESKTOP-J2OHHFH 192.168.2.28 root Update
insert into rujuk_masuk values('2025/07/02/000154','Klinik Fellita','-','0069B0310725Y000028','0','Klinik Fellita','Z32.0','-','-','')
Foreign key constraint fails for table `mesrabaru`.`rujuk_masuk`:
,
  CONSTRAINT `rujuk_masuk_ibfk_2` FOREIGN KEY (`kd_penyakit`) REFERENCES `penyakit` (`kd_penyakit`) ON UPDATE CASCADE in parent table, in index kd_penyakit tuple:
DATA TUPLE: 2 fields;
 0: len 5; hex 5a33322e30; asc Z32.0;;
 1: len 17; hex 323032352f30372f30322f303030313534; asc 2025/07/02/000154;;

But in parent table `mesrabaru`.`penyakit`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 3; hex 5a3333; asc Z33;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 26; hex 507265676e616e742073746174652c20696e636964656e74616c; asc Pregnant state, incidental;;
 4: len 1; hex 2d; asc -;;
 5: len 1; hex 2d; asc -;;
 6: len 1; hex 2d; asc -;;
 7: len 1; hex 02; asc  ;;

------------
TRANSACTIONS
------------
Trx id counter 3803767
Purge done for trx's n:o < 3803767 undo n:o < 0 state: running but idle
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283814739846560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739842392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739825720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739904912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739900744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739871568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739867400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739804880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739784040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739942424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739771536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739834056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739921584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739796544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739909080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739800712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739913248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739859064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739863232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739875736, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739884072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739879904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739854896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739838224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739829888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739821552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739817384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739813216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739775704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739792376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739788208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739779872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283814739809048, 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
296905 OS file reads, 280405 OS file writes, 175569 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 29.99 writes/s, 16.25 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 24, seg size 26, 9049 merges
merged operations:
 insert 10800, delete mark 15058, delete 12676
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 1106407, node heap has 861 buffer(s)
Hash table size 1106407, node heap has 170 buffer(s)
Hash table size 1106407, node heap has 12 buffer(s)
Hash table size 1106407, node heap has 71 buffer(s)
Hash table size 1106407, node heap has 179 buffer(s)
Hash table size 1106407, node heap has 560 buffer(s)
Hash table size 1106407, node heap has 37 buffer(s)
Hash table size 1106407, node heap has 108 buffer(s)
46.24 hash searches/s, 104.47 non-hash searches/s
---
LOG
---
Log sequence number 10676887985
Log flushed up to   10676887963
Pages flushed up to 10676886267
Last checkpoint at  10676881757
0 pending log flushes, 0 pending chkp writes
50460 log i/o's done, 6.75 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 4462739456
Dictionary memory allocated 2511512
Buffer pool size   256864
Free buffers       8192
Database pages     246674
Old database pages 90893
Modified db pages  48
Percent of dirty pages(LRU & free pages): 0.019
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8959, not young 3047600
0.00 youngs/s, 0.00 non-youngs/s
Pages read 295897, created 1373, written 183987
0.00 reads/s, 0.00 creates/s, 18.50 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: 246674, unzip_LRU len: 0
I/O sum[1792]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   32108
Free buffers       1024
Database pages     30824
Old database pages 11358
Modified db pages  16
Percent of dirty pages(LRU & free pages): 0.050
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1135, not young 380540
0.00 youngs/s, 0.00 non-youngs/s
Pages read 36596, created 204, written 24960
0.00 reads/s, 0.00 creates/s, 5.75 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: 30824, unzip_LRU len: 0
I/O sum[224]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   32108
Free buffers       1024
Database pages     30831
Old database pages 11360
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 1029, not young 410657
0.00 youngs/s, 0.00 non-youngs/s
Pages read 38279, created 77, written 17164
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: 30831, unzip_LRU len: 0
I/O sum[224]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   32108
Free buffers       1024
Database pages     30829
Old database pages 11360
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.016
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1086, not young 397547
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37055, created 202, written 18107
0.00 reads/s, 0.00 creates/s, 3.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: 30829, unzip_LRU len: 0
I/O sum[224]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   32108
Free buffers       1024
Database pages     30805
Old database pages 11351
Modified db pages  21
Percent of dirty pages(LRU & free pages): 0.066
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1145, not young 411010
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37074, created 127, written 32345
0.00 reads/s, 0.00 creates/s, 7.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: 30805, unzip_LRU len: 0
I/O sum[224]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   32108
Free buffers       1024
Database pages     30862
Old database pages 11372
Modified db pages  1
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 1279, not young 397634
0.00 youngs/s, 0.00 non-youngs/s
Pages read 37612, created 189, written 30260
0.00 reads/s, 0.00 creates/s, 0.75 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: 30862, unzip_LRU len: 0
I/O sum[224]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   32108
Free buffers       1024
Database pages     30851
Old database pages 11368
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 1087, not young 281747
0.00 youngs/s, 0.00 non-youngs/s
Pages read 35810, created 175, written 18578
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: 30851, unzip_LRU len: 0
I/O sum[224]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   32108
Free buffers       1024
Database pages     30852
Old database pages 11368
Modified db pages  5
Percent of dirty pages(LRU & free pages): 0.016
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1172, not young 376563
0.00 youngs/s, 0.00 non-youngs/s
Pages read 36805, created 231, written 24779
0.00 reads/s, 0.00 creates/s, 1.75 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: 30852, unzip_LRU len: 0
I/O sum[224]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   32108
Free buffers       1024
Database pages     30820
Old database pages 11356
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 1026, not young 391902
0.00 youngs/s, 0.00 non-youngs/s
Pages read 36666, created 168, written 17794
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: 30820, unzip_LRU len: 0
I/O sum[224]: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=11420, Main thread ID=4512, state: sleeping
Number of rows inserted 51280, updated 3744, deleted 4879, read 7330704035
2.75 inserts/s, 0.00 updates/s, 2.50 deletes/s, 103462.13 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
============================