Konsol
Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variabel | Penampungan Penyangga | Status InnoDB ]
=====================================
2024-10-06 11:29:08 0x6f4 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 16 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 16421 srv_active, 0 srv_shutdown, 167748 srv_idle
srv_master_thread log flush and writes: 184169
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 311333
OS WAIT ARRAY INFO: signal count 407257
RW-shared spins 1669476, rounds 16944655, OS waits 300709
RW-excl spins 282949, rounds 1563115, OS waits 3463
RW-sx spins 372, rounds 4254, OS waits 114
Spin rounds per wait: 10.15 RW-shared, 5.52 RW-excl, 11.44 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2024-10-06 11:11:21 0x1a04 Transaction:
TRANSACTION 28051434, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 549106, OS thread handle 6660, query id 3506379 192.168.10.42 root Update
insert into penilaian_awal_keperawatan_kebidanan_ranap values('','2024-10-06 10:52:53','Autoanamnesis','Kursi Roda','VK','os datang keluar lendir darah banyak disertai keluar air-air sejak pukul 05.00 shubuh dan mules sampai kepinggang.','tidak ada','tidak ada\n','tidak ada','tidak ada','Tidak','-','15','5','2','28','Teratur','Tidak Ada Masalah','Menikah','1','-','-','-','-','-','-','5','4','0','4','2023-12-06','38','2024-10-18','Tidak Pernah','2','-','Teratur','Tidak Ada','Tidak Ada','Belum Pernah','-','Tidak Ada','-','-','-','Tidak Ada','-','-','Tidak','-','Tidak','-','Tidak','Cm','Baik','15
Foreign key constraint fails for table `sik`.`penilaian_awal_keperawatan_kebidanan_ranap`:
,
CONSTRAINT `penilaian_awal_keperawatan_kebidanan_ranap_ibfk_1` FOREIGN KEY (`no_rawat`) REFERENCES `reg_periksa` (`no_rawat`) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index PRIMARY tuple:
DATA TUPLE: 164 fields;
0: len 0; hex ; asc ;;
1: len 6; hex 000001ac07ea; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 5; hex 99b48cad35; asc 5;;
4: len 1; hex 01; asc ;;
5: len 1; hex 02; asc ;;
6: len 1; hex 03; asc ;;
7: len 114; hex 6f7320646174616e67206b656c756172206c656e6469722064617261682062616e79616b206469736572746169206b656c756172206169722d6169722073656a616b2070756b756c2030352e3030207368756275682064616e206d756c65732073616d706169206b6570696e6767616e672e; asc os datang keluar lendir darah banyak disertai keluar air-air sejak pukul 05.00 shubuh dan mules sampai kepinggang.;;
8: len 9; hex 746964616b20616461; asc tidak ada;;
9: len 10; hex 746964616b206164610a; asc tidak ada ;;
10: len 9; hex 746964616b20616461; asc tidak ada;;
11: len 9; hex 746964616b20616461; asc tidak ada;;
12: len 1; hex 01; asc ;;
13: len 1; hex 2d; asc -;;
14: len 2; hex 3135; asc 15;;
15: len 1; hex 35; asc 5;;
16: len 1; hex 32; asc 2;;
17: len 2; hex 3238; asc 28;;
18: len 1; hex 01; asc ;;
19: len 1; hex 01; asc ;;
20: len 1; hex 01; asc ;;
21: len 1; hex 31; asc 1;;
22: len 1; hex 2d; asc -;;
23: len 1; hex 01; asc ;;
24: len 1; hex 2d; asc -;;
25: len 1; hex 01; asc ;;
26: len 1; hex 2d; asc -;;
27: len 1; hex 01; asc ;;
28: len 1; hex 35; asc 5;;
29: len 1; hex 34; asc 4;;
30: len 1; hex 30; asc 0;;
31: len 1; hex 34; asc 4;;
32: len 3; hex 8fcf86; asc ;;
33: len 2; hex 3338; asc 38;;
34: len 3; hex 8fd152; asc R;;
35: len 1; hex 01; asc ;;
36: len 1; hex 32; asc 2;;
37: len 1; hex 2d; asc -;;
38: len 1; hex 01; asc ;;
39: len 1; hex 01; asc ;;
40: len 1; hex 01; asc ;;
41: len 1; hex 01; asc ;;
42: len 1; hex 2d; asc -;;
43: len 1; hex 01; asc ;;
44: len 1; hex 2d; asc -;;
45: len 1; hex 2d; asc -;;
46: len 1; hex 2d; asc -;;
47: len 1; hex 01; asc ;;
48: len 1; hex 01; asc ;;
49: len 1; hex 2d; asc -;;
50: len 1; hex 01; asc ;;
51: len 1; hex 2d; asc -;;
52: len 1; hex 01; asc ;;
53: len 1; hex 2d; asc -;;
54: len 1; hex 01; asc ;;
55: len 2; hex 436d; asc Cm;;
56: len 1; hex 01; asc ;;
57: len 2; hex 3135; asc 15;;
58: len 6; hex 3132302f3830; asc 120/80;;
59: len 2; hex 3830; asc 80;;
60: len 2; hex 3231; asc 21;;
61: len 4; hex 33362c38; asc 36,8;;
62: len 2; hex 3939; asc 99;;
63: len 2; hex 3632; asc 62;;
64: len 3; hex 313535; asc 155;;
65: len 2; hex 3330; asc 30;;
66: len 2; hex 3330; asc 30;;
67: len 4; hex 32363335; asc 2635;;
68: len 5; hex 6b65706c61; asc kepla;;
69: len 6; hex 6b6570616c61; asc kepala;;
70: len 1; hex 30; asc 0;;
71: len 6; hex 736564616e64; asc sedand;;
72: len 6; hex 736564616e67; asc sedang;;
73: len 2; hex 3135; asc 15;;
74: len 3; hex 313530; asc 150;;
75: len 1; hex 01; asc ;;
76: len 5; hex 746562616c; asc tebal;;
77: len 1; hex 32; asc 2;;
78: len 4; hex 75747568; asc utuh;;
79: len 1; hex 31; asc 1;;
80: len 1; hex 01; asc ;;
81: len 1; hex 02; asc ;;
82: len 1; hex 2d; asc -;;
83: len 1; hex 02; asc ;;
84: len 1; hex 2d; asc -;;
85: len 1; hex 02; asc ;;
86: len 1; hex 2d; asc -;;
87: len 1; hex 01; asc ;;
88: len 1; hex 01; asc ;;
89: len 1; hex 01; asc ;;
90: len 1; hex 01; asc ;;
91: len 1; hex 01; asc ;;
92: len 1; hex 01; asc ;;
93: len 1; hex 01; asc ;;
94: len 1; hex 01; asc ;;
95: len 1; hex 01; asc ;;
96: len 1; hex 01; asc ;;
97: len 1; hex 01; asc ;;
98: len 1; hex 01; asc ;;
99: len 1; hex 01; asc ;;
100: len 1; hex 2d; asc -;;
101: len 1; hex 01; asc ;;
102: len 1; hex 01; asc ;;
103: len 1; hex 01; asc ;;
104: len 1; hex 2d; asc -;;
105: len 1; hex 01; asc ;;
106: len 1; hex 2d; asc -;;
107: len 1; hex 01; asc ;;
108: len 1; hex 2d; asc -;;
109: len 1; hex 01; asc ;;
110: len 1; hex 2d; asc -;;
111: len 1; hex 01; asc ;;
112: len 1; hex 01; asc ;;
113: len 1; hex 01; asc ;;
114: len 1; hex 2d; asc -;;
115: len 1; hex 01; asc ;;
116: len 1; hex 01; asc ;;
117: len 1; hex 01; asc ;;
118: len 1; hex 2d; asc -;;
119: len 1; hex 01; asc ;;
120: len 1; hex 2d; asc -;;
121: len 1; hex 01; asc ;;
122: len 1; hex 01; asc ;;
123: len 1; hex 2d; asc -;;
124: len 1; hex 01; asc ;;
125: len 1; hex 01; asc ;;
126: len 1; hex 2d; asc -;;
127: len 1; hex 01; asc ;;
128: len 1; hex 2d; asc -;;
129: len 7; hex 6162646f6d656e; asc abdomen;;
130: len 1; hex 02; asc ;;
131: len 1; hex 04; asc ;;
132: len 1; hex 32; asc 2;;
133: len 1; hex 01; asc ;;
134: len 1; hex 2d; asc -;;
135: len 1; hex 02; asc ;;
136: len 5; hex 31302e3030; asc 10.00;;
137: len 1; hex 01; asc ;;
138: len 1; hex 80; asc ;;
139: len 1; hex 01; asc ;;
140: len 1; hex 80; asc ;;
141: len 1; hex 01; asc ;;
142: len 1; hex 80; asc ;;
143: len 1; hex 01; asc ;;
144: len 1; hex 80; asc ;;
145: len 1; hex 01; asc ;;
146: len 1; hex 80; asc ;;
147: len 1; hex 01; asc ;;
148: len 1; hex 80; asc ;;
149: len 8; hex 0000000000000000; asc ;;
150: len 1; hex 01; asc ;;
151: len 4; hex 80000000; asc ;;
152: len 1; hex 01; asc ;;
153: len 4; hex 80000000; asc ;;
154: len 8; hex 0000000000000000; asc ;;
155: len 1; hex 01; asc ;;
156: len 1; hex 2d; asc -;;
157: len 1; hex 02; asc ;;
158: len 5; hex 31302e3030; asc 10.00;;
159: len 87; hex 6962752047355034413020756b20617465726d2c696e7061727475206b616c6120312066617365206c6174656e2c206a68742c6975202c707265736b6570206b2f75206962752064616e206a616e696e206261696b202e; asc ibu G5P4A0 uk aterm,inpartu kala 1 fase laten, jht,iu ,preskep k/u ibu dan janin baik .;;
160: len 14; hex 6f627365727661736920646a6a20; asc observasi djj ;;
161: len 10; hex 33303632303131363133; asc 3062011613;;
162: len 10; hex 33303632303132313731; asc 3062012171;;
163: len 4; hex 64723031; asc dr01;;
But in parent table `sik`.`reg_periksa`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 21; compact format; info bits 0
0: len 17; hex 323032322f30352f31352f303030303036; asc 2022/05/15/000006;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 3; hex 303031; asc 001;;
4: len 3; hex 8fccaf; asc ;;
5: len 3; hex 814582; asc E ;;
6: len 10; hex 32303231303131373230; asc 2021011720;;
7: len 6; hex 303338393738; asc 038978;;
8: len 5; hex 5530303031; asc U0001;;
9: len 13; hex 4645524920534554494157414e; asc FERI SETIAWAN;;
10: len 14; hex 50414c41532c202d2c202d2c202d; asc PALAS, -, -, -;;
11: len 5; hex 5355414d49; asc SUAMI;;
12: len 8; hex 000000000088c340; asc @;;
13: len 1; hex 02; asc ;;
14: len 1; hex 03; asc ;;
15: len 1; hex 01; asc ;;
16: len 3; hex 42504a; asc BPJ;;
17: len 4; hex 8000001d; asc ;;
18: len 1; hex 01; asc ;;
19: len 1; hex 02; asc ;;
20: len 1; hex 02; asc ;;
------------
TRANSACTIONS
------------
Trx id counter 28054951
Purge done for trx's n:o < 28054951 undo n:o < 0 state: running but idle
History list length 2
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284034708945640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708941464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708862120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708849592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708899704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708937288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708933112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708928936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708924760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708845416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708853768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708837064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708920584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708912232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708908056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708895528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708891352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708887176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708883000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708878824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708857944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708874648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708870472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708816184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708866296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708841240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708828712, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708820360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708812008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708832888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708807832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708916408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708903880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284034708824536, 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
28647986 OS file reads, 406160 OS file writes, 190928 OS fsyncs
119.24 reads/s, 16384 avg bytes/read, 3.56 writes/s, 2.56 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 76, seg size 78, 64680 merges
merged operations:
insert 133445, delete mark 17249, delete 4123
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 2 buffer(s)
Hash table size 4441, node heap has 12 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)
6130.55 hash searches/s, 429.29 non-hash searches/s
---
LOG
---
Log sequence number 5685040034
Log flushed up to 5685040034
Pages flushed up to 5685040034
Last checkpoint at 5685037383
0 pending log flushes, 0 pending chkp writes
101648 log i/o's done, 1.44 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 7076304
Buffer pool size 1003
Free buffers 725
Database pages 258
Old database pages 0
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 3324620, not young 2073507763
0.62 youngs/s, 4875.82 non-youngs/s
Pages read 28645156, created 2393, written 278333
119.31 reads/s, 0.00 creates/s, 1.69 writes/s
Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 242 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 258, unzip_LRU len: 0
I/O sum[4701]:cur[5], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=3552, Main thread ID=4952, state: sleeping
Number of rows inserted 79717, updated 7339, deleted 5568, read 3541909914
0.00 inserts/s, 0.31 updates/s, 0.00 deletes/s, 8517.41 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 115031
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================