MYSQL:阅读 SHOW ENGINE INNODB STATUS 内容
Lock wait timeout exceeded; try restarting transaction trx_state=”RUNNING”
当您在数据库操作中遇到“Lock wait timeout exceeded; try restarting transaction”这样的错误时,这通常意味着您的数据库事务因为无法及时获取所需的锁而超出了锁等待的超时限制。这种情况常见于使用InnoDB存储引擎的MySQL数据库中。以下是一些解决这个问题的步骤和建议:
1. 分析和优化事务
查看当前锁定情况:
执行SQL命令: SHOW ENGINE INNODB STATUS;
返回内容 :
=====================================
2025-02-18 08:38:14 0x3898 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 9 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 21376 srv_active, 0 srv_shutdown, 3660877 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1362348
OS WAIT ARRAY INFO: signal count 1489071
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2025-02-16 09:20:48 0x1f3c
*** (1) TRANSACTION:
TRANSACTION 136829, ACTIVE 48 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 6895 lock struct(s), heap size 843896, 965307 row lock(s), undo log entries 6
MySQL thread id 5533, OS thread handle 21244, query id 4810543 localhost 127.0.0.1 hibuser updating
UPDATE apps.oe_order_headers
SET ORDER_NUMBER = 113200018839
, ORG_ID = 163
, CUST_PO_NUMBER = null
, LAST_UPDATE_DATE = '2025-02-16 09:09:27.0'
, LAST_UPDATED_BY = 1115
, CREATION_DATE = '2024-12-27 15:25:30.0'
, CREATED_BY = 6020
, LAST_UPDATE_LOGIN = 286019258
, attribute1 = 'N00131'
WHERE ( ( header_id = 40273037 ) )
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 103 page no 5 n bits 224 index GEN_CLUST_INDEX of table `apps`.`oe_order_headers` trx id 136829 lock_mode X
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;
Record lock, heap no 2 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003533b; asc S;;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40110; asc ;;
3: len 8; hex 800000000245cd15; asc E ;;
4: len 8; hex 800000a33cd36e69; asc < ni;;
5: len 8; hex 80000000000000ea; asc ;;
6: len 16; hex 435051433234303931392d3030323436; asc CPQC240919-00246;;
7: len 5; hex 99b472a854; asc r T;;
8: len 8; hex 80000000000050cf; asc P ;;
9: len 5; hex 99b472a852; asc r R;;
10: len 8; hex 80000000000050cf; asc P ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 3 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003533c; asc S<;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4011f; asc ;;
3: len 8; hex 800000000245cd16; asc E ;;
4: len 8; hex 8000008bb30b04cb; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 16; hex 435051433234303932342d3035313031; asc CPQC240924-05101;;
7: len 5; hex 99b472a8b6; asc r ;;
8: len 8; hex 80000000000009f0; asc ;;
9: len 5; hex 99b472a889; asc r ;;
10: len 8; hex 80000000000009f0; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 4 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003533d; asc S=;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4012e; asc .;;
3: len 8; hex 800000000245cd17; asc E ;;
4: len 8; hex 8000008c2ff7ee0a; asc / ;;
5: len 8; hex 80000000000000c2; asc ;;
6: len 17; hex 4949504f32303234303932342d30303732; asc IIPO20240924-0072;;
7: len 5; hex 99b472a88a; asc r ;;
8: len 8; hex 800000000000153d; asc =;;
9: len 5; hex 99b472a88a; asc r ;;
10: len 8; hex 800000000000153d; asc =;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 5 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003533e; asc S>;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4013d; asc =;;
3: len 8; hex 800000000245cd1f; asc E ;;
4: len 8; hex 80000054133f743f; asc T ?t?;;
5: len 8; hex 8000000000000294; asc ;;
6: len 16; hex 435051433234303732342d3030343432; asc CPQC240724-00442;;
7: len 5; hex 99b472a904; asc r ;;
8: len 8; hex 80000000000006e5; asc ;;
9: len 5; hex 99b472a903; asc r ;;
10: len 8; hex 80000000000006e5; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 6 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003533f; asc S?;;
1: len 6; hex 000000002569; asc %i;;
2: len 7; hex 010000014c0d70; asc L p;;
3: len 8; hex 800000000245d502; asc E ;;
4: len 8; hex 800000ba43b90eef; asc C ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 485451433230323430393233303030333730; asc HTQC20240923000370;;
7: len 5; hex 99b472b560; asc r `;;
8: len 8; hex 80000000000064ff; asc d ;;
9: len 5; hex 99b472a9f7; asc r ;;
10: len 8; hex 80000000000064ff; asc d ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 8 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035341; asc SA;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4016a; asc j;;
3: len 8; hex 800000000245cbd3; asc E ;;
4: len 8; hex 8000001c6dc3cc72; asc m r;;
5: len 8; hex 8000000000000078; asc x;;
6: len 16; hex 435051433234303932352d3030313031; asc CPQC240925-00101;;
7: len 5; hex 99b4729987; asc r ;;
8: len 8; hex 80000000000069f0; asc i ;;
9: len 5; hex 99b4729987; asc r ;;
10: len 8; hex 80000000000069f0; asc i ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 9 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035342; asc SB;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40179; asc y;;
3: len 8; hex 800000000245cc61; asc E a;;
4: len 8; hex 80000053d7a59dd2; asc S ;;
5: len 8; hex 8000000000000293; asc ;;
6: len 18; hex 485451433230323430393233303030343231; asc HTQC20240923000421;;
7: len 5; hex 99b4729e64; asc r d;;
8: len 8; hex 8000000000001bed; asc ;;
9: len 5; hex 99b4729e48; asc r H;;
10: len 8; hex 8000000000001bed; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 10 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035343; asc SC;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40188; asc ;;
3: len 8; hex 800000000245cc83; asc E ;;
4: len 8; hex 80000017e3a2327b; asc 2{;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030323234; asc CPQC240925-00224;;
7: len 5; hex 99b472a120; asc r ;;
8: len 8; hex 80000000000004b9; asc ;;
9: len 5; hex 99b472a115; asc r ;;
10: len 8; hex 80000000000004b9; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 12 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035345; asc SE;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c401a6; asc ;;
3: len 8; hex 800000000245ccd3; asc E ;;
4: len 8; hex 80000017e3a232d1; asc 2 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 18; hex 485451433230323430393139303030343731; asc HTQC20240919000471;;
7: len 5; hex 99b472a50f; asc r ;;
8: len 8; hex 8000000000001843; asc C;;
9: len 5; hex 99b472a505; asc r ;;
10: len 8; hex 8000000000001843; asc C;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 13 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035346; asc SF;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c401b5; asc ;;
3: len 8; hex 800000000245d535; asc E 5;;
4: len 8; hex 8000001bf694c3c9; asc ;;
5: len 8; hex 8000000000000053; asc S;;
6: len 16; hex 435051433234303932352d3030313939; asc CPQC240925-00199;;
7: len 5; hex 99b472abbb; asc r ;;
8: len 8; hex 800000000000586e; asc Xn;;
9: len 5; hex 99b472abba; asc r ;;
10: len 8; hex 800000000000586e; asc Xn;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 16 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035349; asc SI;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c401e2; asc ;;
3: len 8; hex 800000000245d547; asc E G;;
4: len 8; hex 80000017e3a2338c; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3031393232; asc CPQC240924-01922;;
7: len 5; hex 99b472ac6d; asc r m;;
8: len 8; hex 8000000000000de7; asc ;;
9: len 5; hex 99b472ac59; asc r Y;;
10: len 8; hex 8000000000000de7; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 17 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003534a; asc SJ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c401f1; asc ;;
3: len 8; hex 800000000245d54e; asc E N;;
4: len 8; hex 80000019de13fe55; asc U;;
5: len 8; hex 8000000000000059; asc Y;;
6: len 16; hex 435051433234303931392d3031303732; asc CPQC240919-01072;;
7: len 5; hex 99b472acc6; asc r ;;
8: len 8; hex 80000000000056d5; asc V ;;
9: len 5; hex 99b472acc5; asc r ;;
10: len 8; hex 80000000000056d5; asc V ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 18 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003534b; asc SK;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40200; asc ;;
3: len 8; hex 800000000245d54f; asc E O;;
4: len 8; hex 80000017e3a23391; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030333636; asc CPQC240925-00366;;
7: len 5; hex 99b472ace2; asc r ;;
8: len 8; hex 80000000000033e4; asc 3 ;;
9: len 5; hex 99b472accb; asc r ;;
10: len 8; hex 80000000000033e4; asc 3 ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 19 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003534c; asc SL;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4020f; asc ;;
3: len 8; hex 800000000245cb97; asc E ;;
4: len 8; hex 80000017e3a23195; asc 1 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 18; hex 485451433230323430393039303030343538; asc HTQC20240909000458;;
7: len 5; hex 99b472965f; asc r _;;
8: len 8; hex 8000000000006833; asc h3;;
9: len 5; hex 99b4729652; asc r R;;
10: len 8; hex 8000000000006833; asc h3;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 20 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003534d; asc SM;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4021e; asc ;;
3: len 8; hex 800000000245ccef; asc E ;;
4: len 8; hex 80000017e3a232f6; asc 2 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303931392d3030373834; asc CPQC240919-00784;;
7: len 5; hex 99b472a69f; asc r ;;
8: len 8; hex 80000000000037f4; asc 7 ;;
9: len 5; hex 99b472a695; asc r ;;
10: len 8; hex 80000000000037f4; asc 7 ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 21 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003534e; asc SN;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4022d; asc -;;
3: len 8; hex 800000000245ccf3; asc E ;;
4: len 8; hex 80000017e3a232fc; asc 2 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3032313232; asc CPQC240924-02122;;
7: len 5; hex 99b472a6cd; asc r ;;
8: len 8; hex 8000000000001bed; asc ;;
9: len 5; hex 99b472a6c2; asc r ;;
10: len 8; hex 8000000000001bed; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 22 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003534f; asc SO;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4023c; asc <;;
3: len 8; hex 800000000245ccf4; asc E ;;
4: len 8; hex 80000017e3a232fd; asc 2 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3032313232; asc CPQC240924-02122;;
7: len 5; hex 99b472a6c4; asc r ;;
8: len 8; hex 8000000000001bed; asc ;;
9: len 5; hex 99b472a6c4; asc r ;;
10: len 8; hex 8000000000001bed; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 23 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035350; asc SP;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4024b; asc K;;
3: len 8; hex 800000000245ccfb; asc E ;;
4: len 8; hex 80000017e3a2330b; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3031393537; asc CPQC240924-01957;;
7: len 5; hex 99b472a74d; asc r M;;
8: len 8; hex 80000000000053d7; asc S ;;
9: len 5; hex 99b472a744; asc r D;;
10: len 8; hex 80000000000053d7; asc S ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 24 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035351; asc SQ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4025a; asc Z;;
3: len 8; hex 800000000245cd06; asc E ;;
4: len 8; hex 80000017e3a23315; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030373533; asc CPQC240925-00753;;
7: len 5; hex 99b472a7a0; asc r ;;
8: len 8; hex 8000000000006548; asc eH;;
9: len 5; hex 99b472a79f; asc r ;;
10: len 8; hex 8000000000006548; asc eH;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 25 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035352; asc SR;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40269; asc i;;
3: len 8; hex 800000000245cd12; asc E ;;
4: len 8; hex 8000008d3c2d7994; asc <-y ;;
5: len 8; hex 80000000000001fc; asc ;;
6: len 18; hex 595053513230323430393235303030303338; asc YPSQ20240925000038;;
7: len 5; hex 99b472a84d; asc r M;;
8: len 8; hex 8000000000006e03; asc n ;;
9: len 5; hex 99b472a84d; asc r M;;
10: len 8; hex 8000000000006e03; asc n ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 26 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035353; asc SS;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40278; asc x;;
3: len 8; hex 800000000245d510; asc E ;;
4: len 8; hex 80000059a9bfeb97; asc Y ;;
5: len 8; hex 8000000000000423; asc #;;
6: len 14; hex 4b4c313032333032343339353636; asc KL102302439566;;
7: len 5; hex 99b472aa81; asc r ;;
8: len 8; hex 8000000000000d0f; asc ;;
9: len 5; hex 99b472aa81; asc r ;;
10: len 8; hex 8000000000000d0f; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 27 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035354; asc ST;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40287; asc ;;
3: len 8; hex 800000000245cb2e; asc E .;;
4: len 8; hex 8000005fe7274534; asc _ 'E4;;
5: len 8; hex 80000000000004e0; asc ;;
6: len 14; hex 4b4c313032333032343338373738; asc KL102302438778;;
7: len 5; hex 99b47290c3; asc r ;;
8: len 8; hex 80000000000009eb; asc ;;
9: len 5; hex 99b47290c3; asc r ;;
10: len 8; hex 80000000000009eb; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 28 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035355; asc SU;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40296; asc ;;
3: len 8; hex 800000000245cca9; asc E ;;
4: len 8; hex 8000008bb30b0485; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 4350514359503234303932352d3030333738; asc CPQCYP240925-00378;;
7: len 5; hex 99b472a337; asc r 7;;
8: len 8; hex 8000000000003883; asc 8 ;;
9: len 5; hex 99b472a31c; asc r ;;
10: len 8; hex 8000000000003883; asc 8 ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 29 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035356; asc SV;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c402a5; asc ;;
3: len 8; hex 800000000245cb50; asc E P;;
4: len 8; hex 80000054133f741f; asc T ?t ;;
5: len 8; hex 8000000000000294; asc ;;
6: len 18; hex 4350514359503234303932342d3030353930; asc CPQCYP240924-00590;;
7: len 5; hex 99b4729260; asc r `;;
8: len 8; hex 80000000000009e9; asc ;;
9: len 5; hex 99b4729260; asc r `;;
10: len 8; hex 80000000000009e9; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 30 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035357; asc SW;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c402b4; asc ;;
3: len 8; hex 800000000245cc23; asc E #;;
4: len 8; hex 80000054133f742f; asc T ?t/;;
5: len 8; hex 8000000000000294; asc ;;
6: len 16; hex 435051433234303932342d3030353834; asc CPQC240924-00584;;
7: len 5; hex 99b4729c4d; asc r M;;
8: len 8; hex 8000000000001723; asc #;;
9: len 5; hex 99b4729c4c; asc r L;;
10: len 8; hex 8000000000001723; asc #;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 31 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035358; asc SX;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c402c3; asc ;;
3: len 8; hex 800000000245cc87; asc E ;;
4: len 8; hex 80000017e41a431e; asc C ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 18; hex 4350514359503234303932352d3030343132; asc CPQCYP240925-00412;;
7: len 5; hex 99b472a191; asc r ;;
8: len 8; hex 800000000000422f; asc B/;;
9: len 5; hex 99b472a188; asc r ;;
10: len 8; hex 800000000000422f; asc B/;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 32 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035359; asc SY;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c402d2; asc ;;
3: len 8; hex 800000000245cc94; asc E ;;
4: len 8; hex 80000017e3a23285; asc 2 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030343830; asc CPQC240925-00480;;
7: len 5; hex 99b472a209; asc r ;;
8: len 8; hex 8000000000000cf9; asc ;;
9: len 5; hex 99b472a209; asc r ;;
10: len 8; hex 8000000000000cf9; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 33 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003535a; asc SZ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c402e1; asc ;;
3: len 8; hex 800000000245cc95; asc E ;;
4: len 8; hex 80000017e41a4323; asc C#;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 18; hex 4350514359503234303932352d3030333432; asc CPQCYP240925-00342;;
7: len 5; hex 99b472a22d; asc r -;;
8: len 8; hex 80000000000066a2; asc f ;;
9: len 5; hex 99b472a22c; asc r ,;;
10: len 8; hex 80000000000066a2; asc f ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 34 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003535b; asc S[;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c402f0; asc ;;
3: len 8; hex 800000000245d4fb; asc E ;;
4: len 8; hex 8000008bb30b04d5; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 4350514359503234303932352d3030343539; asc CPQCYP240925-00459;;
7: len 5; hex 99b472a9cf; asc r ;;
8: len 8; hex 8000000000006241; asc bA;;
9: len 5; hex 99b472a99a; asc r ;;
10: len 8; hex 8000000000006241; asc bA;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 35 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003535c; asc S\;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c402ff; asc ;;
3: len 8; hex 800000000245d506; asc E ;;
4: len 8; hex 8000008bb30b04da; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 4350514359503234303932352d3030343539; asc CPQCYP240925-00459;;
7: len 5; hex 99b472aa4a; asc r J;;
8: len 8; hex 8000000000006241; asc bA;;
9: len 5; hex 99b472aa1a; asc r ;;
10: len 8; hex 8000000000006241; asc bA;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 36 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003535d; asc S];;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4030e; asc ;;
3: len 8; hex 800000000245cb13; asc E ;;
4: len 8; hex 80000017e3a2310e; asc 1 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3032313931; asc CPQC240924-02191;;
7: len 5; hex 99b4728ed5; asc r ;;
8: len 8; hex 800000000000467c; asc F|;;
9: len 5; hex 99b4728ec9; asc r ;;
10: len 8; hex 800000000000467c; asc F|;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 37 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003535e; asc S^;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4031d; asc ;;
3: len 8; hex 800000000245cb14; asc E ;;
4: len 8; hex 80000017e3a23110; asc 1 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3032313931; asc CPQC240924-02191;;
7: len 5; hex 99b4728ecb; asc r ;;
8: len 8; hex 8000000000001705; asc ;;
9: len 5; hex 99b4728ecb; asc r ;;
10: len 8; hex 8000000000001705; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 38 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003535f; asc S_;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4032c; asc ,;;
3: len 8; hex 800000000245cb36; asc E 6;;
4: len 8; hex 80000017e3a23132; asc 12;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3032303331; asc CPQC240924-02031;;
7: len 5; hex 99b4729130; asc r 0;;
8: len 8; hex 8000000000000d03; asc ;;
9: len 5; hex 99b4729123; asc r #;;
10: len 8; hex 8000000000000d03; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 39 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035360; asc S`;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4033b; asc ;;;
3: len 8; hex 800000000245cb5f; asc E _;;
4: len 8; hex 80000017e41a42cd; asc B ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 18; hex 4350514359503234303932352d3030333135; asc CPQCYP240925-00315;;
7: len 5; hex 99b472932a; asc r *;;
8: len 8; hex 8000000000001044; asc D;;
9: len 5; hex 99b472932a; asc r *;;
10: len 8; hex 8000000000001044; asc D;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 40 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035361; asc Sa;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4034a; asc J;;
3: len 8; hex 800000000245cb63; asc E c;;
4: len 8; hex 80000017e3a2315b; asc 1[;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030313035; asc CPQC240925-00105;;
7: len 5; hex 99b472935e; asc r ^;;
8: len 8; hex 8000000000000a97; asc ;;
9: len 5; hex 99b472935d; asc r ];;
10: len 8; hex 8000000000000a97; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 41 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035362; asc Sb;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40359; asc Y;;
3: len 8; hex 800000000245cb6a; asc E j;;
4: len 8; hex 80000017e3a23167; asc 1g;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932332d3032333236; asc CPQC240923-02326;;
7: len 5; hex 99b4729402; asc r ;;
8: len 8; hex 8000000000003ac7; asc : ;;
9: len 5; hex 99b47293f5; asc r ;;
10: len 8; hex 8000000000003ac7; asc : ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 42 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035363; asc Sc;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40368; asc h;;
3: len 8; hex 800000000245cb74; asc E t;;
4: len 8; hex 80000017e41a42d8; asc B ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 18; hex 4350514359503234303932342d3031333933; asc CPQCYP240924-01393;;
7: len 5; hex 99b4729469; asc r i;;
8: len 8; hex 8000000000000688; asc ;;
9: len 5; hex 99b4729469; asc r i;;
10: len 8; hex 8000000000000688; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 43 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035364; asc Sd;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40377; asc w;;
3: len 8; hex 800000000245cb8e; asc E ;;
4: len 8; hex 80000017e3a2318d; asc 1 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3031383339; asc CPQC240924-01839;;
7: len 5; hex 99b47295f9; asc r ;;
8: len 8; hex 80000000000007dd; asc ;;
9: len 5; hex 99b47295f9; asc r ;;
10: len 8; hex 80000000000007dd; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 44 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035365; asc Se;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40386; asc ;;
3: len 8; hex 800000000245cc33; asc E 3;;
4: len 8; hex 800000461af7ffea; asc F ;;
5: len 8; hex 80000000000000ef; asc ;;
6: len 16; hex 435051433234303932342d3030363738; asc CPQC240924-00678;;
7: len 5; hex 99b4729ce0; asc r ;;
8: len 8; hex 8000000000006241; asc bA;;
9: len 5; hex 99b4729cc3; asc r ;;
10: len 8; hex 8000000000006241; asc bA;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 45 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035366; asc Sf;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40395; asc ;;
3: len 8; hex 800000000245cc79; asc E y;;
4: len 8; hex 800000464aa48516; asc FJ ;;
5: len 8; hex 80000000000000ef; asc ;;
6: len 18; hex 485451433230323430313036303030353639; asc HTQC20240106000569;;
7: len 5; hex 99b472a0cf; asc r ;;
8: len 8; hex 80000000000041bb; asc A ;;
9: len 5; hex 99b472a096; asc r ;;
10: len 8; hex 80000000000041bb; asc A ;;
11: len 8; hex 80000000103505d3; asc 5 ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 46 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035367; asc Sg;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c403a4; asc ;;
3: len 8; hex 800000000245cc82; asc E ;;
4: len 8; hex 8000004af2bc36d6; asc J 6 ;;
5: len 8; hex 80000000000001bd; asc ;;
6: len 18; hex 485451433230323430313036303030353639; asc HTQC20240106000569;;
7: len 5; hex 99b472a138; asc r 8;;
8: len 8; hex 80000000000041bb; asc A ;;
9: len 5; hex 99b472a113; asc r ;;
10: len 8; hex 80000000000041bb; asc A ;;
11: len 8; hex 80000000103505d3; asc 5 ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 47 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035368; asc Sh;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c403b3; asc ;;
3: len 8; hex 800000000245cc8d; asc E ;;
4: len 8; hex 800000464aa48517; asc FJ ;;
5: len 8; hex 80000000000000ef; asc ;;
6: len 16; hex 435051433234303432332d3032353131; asc CPQC240423-02511;;
7: len 5; hex 99b472a274; asc r t;;
8: len 8; hex 80000000000041bb; asc A ;;
9: len 5; hex 99b472a1cd; asc r ;;
10: len 8; hex 80000000000041bb; asc A ;;
11: len 8; hex 80000000103505d3; asc 5 ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 48 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035369; asc Si;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c403c2; asc ;;
3: len 8; hex 800000000245cca1; asc E ;;
4: len 8; hex 8000004af2bc36d7; asc J 6 ;;
5: len 8; hex 80000000000001bd; asc ;;
6: len 16; hex 435051433234303432332d3032353131; asc CPQC240423-02511;;
7: len 5; hex 99b472a2e0; asc r ;;
8: len 8; hex 80000000000041bb; asc A ;;
9: len 5; hex 99b472a2ca; asc r ;;
10: len 8; hex 80000000000041bb; asc A ;;
11: len 8; hex 80000000103505d3; asc 5 ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 49 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003536a; asc Sj;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c403d1; asc ;;
3: len 8; hex 800000000245cca8; asc E ;;
4: len 8; hex 800000464aa48518; asc FJ ;;
5: len 8; hex 80000000000000ef; asc ;;
6: len 16; hex 435051433234303431392d3031303435; asc CPQC240419-01045;;
7: len 5; hex 99b472a354; asc r T;;
8: len 8; hex 80000000000041bb; asc A ;;
9: len 5; hex 99b472a316; asc r ;;
10: len 8; hex 80000000000041bb; asc A ;;
11: len 8; hex 80000000103505d3; asc 5 ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 50 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003536b; asc Sk;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c403e0; asc ;;
3: len 8; hex 800000000245ccaa; asc E ;;
4: len 8; hex 8000001c6dc3cc8b; asc m ;;
5: len 8; hex 8000000000000078; asc x;;
6: len 18; hex 4350514359503234303932352d3030313731; asc CPQCYP240925-00171;;
7: len 5; hex 99b472a31d; asc r ;;
8: len 8; hex 8000000000005571; asc Uq;;
9: len 5; hex 99b472a31d; asc r ;;
10: len 8; hex 8000000000005571; asc Uq;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 51 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003536c; asc Sl;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c403ef; asc ;;
3: len 8; hex 800000000245ccad; asc E ;;
4: len 8; hex 8000001bf694c39e; asc ;;
5: len 8; hex 8000000000000053; asc S;;
6: len 16; hex 435051433234303932352d3030333835; asc CPQC240925-00385;;
7: len 5; hex 99b472a59d; asc r ;;
8: len 8; hex 80000000000051dd; asc Q ;;
9: len 5; hex 99b472a356; asc r V;;
10: len 8; hex 8000000000000c99; asc ;;
11: len 8; hex 800000001034e331; asc 4 1;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 52 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003536d; asc Sm;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c403fe; asc ;;
3: len 8; hex 800000000245d51c; asc E ;;
4: len 8; hex 80000017e9678b5b; asc g [;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433232303930322d3030313835; asc CPQC220902-00185;;
7: len 5; hex 99b472aae9; asc r ;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472aae8; asc r ;;
10: len 8; hex 800000000000045b; asc [;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 53 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003536e; asc Sn;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4040d; asc ;;
3: len 8; hex 800000000245d51e; asc E ;;
4: len 8; hex 80000017e3a23362; asc 3b;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030353438; asc CPQC240925-00548;;
7: len 5; hex 99b472aaf8; asc r ;;
8: len 8; hex 80000000000016ae; asc ;;
9: len 5; hex 99b472aaf8; asc r ;;
10: len 8; hex 80000000000016ae; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 56 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035371; asc Sq;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4043a; asc :;;
3: len 8; hex 800000000245d52d; asc E -;;
4: len 8; hex 80000017e3a23372; asc 3r;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030313939; asc CPQC240925-00199;;
7: len 5; hex 99b472ab8f; asc r ;;
8: len 8; hex 800000000000586e; asc Xn;;
9: len 5; hex 99b472ab76; asc r v;;
10: len 8; hex 800000000000586e; asc Xn;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 58 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035373; asc Ss;;
1: len 6; hex 000000002569; asc %i;;
2: len 7; hex 010000014c0d96; asc L ;;
3: len 8; hex 800000000245d53e; asc E >;;
4: len 8; hex 80000017e3a23385; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030343833; asc CPQC240925-00483;;
7: len 5; hex 99b472b53a; asc r :;;
8: len 8; hex 80000000000051dd; asc Q ;;
9: len 5; hex 99b472ac19; asc r ;;
10: len 8; hex 80000000000051dd; asc Q ;;
11: len 8; hex 800000001034e331; asc 4 1;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 59 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035374; asc St;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40467; asc g;;
3: len 8; hex 800000000245d552; asc E R;;
4: len 8; hex 80000017e3a23395; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3032303433; asc CPQC240924-02043;;
7: len 5; hex 99b472ad02; asc r ;;
8: len 8; hex 80000000000033e4; asc 3 ;;
9: len 5; hex 99b472ace5; asc r ;;
10: len 8; hex 80000000000033e4; asc 3 ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 60 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035375; asc Su;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40476; asc v;;
3: len 8; hex 800000000245d553; asc E S;;
4: len 8; hex 80000017e3a23396; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3031393132; asc CPQC240924-01912;;
7: len 5; hex 99b472aced; asc r ;;
8: len 8; hex 800000000000091d; asc ;;
9: len 5; hex 99b472acec; asc r ;;
10: len 8; hex 800000000000091d; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 61 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035376; asc Sv;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40485; asc ;;
3: len 8; hex 800000000245d563; asc E c;;
4: len 8; hex 8000008c2ff7ee17; asc / ;;
5: len 8; hex 80000000000000c2; asc ;;
6: len 17; hex 4949504f32303234303932352d30303238; asc IIPO20240925-0028;;
7: len 5; hex 99b472adb8; asc r ;;
8: len 8; hex 8000000000001a7c; asc |;;
9: len 5; hex 99b472adb6; asc r ;;
10: len 8; hex 8000000000001a7c; asc |;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 62 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035377; asc Sw;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40494; asc ;;
3: len 8; hex 800000000245cb3a; asc E :;;
4: len 8; hex 8000001c32233849; asc 2#8I;;
5: len 8; hex 800000000000005a; asc Z;;
6: len 16; hex 435051433234303932342d3032303331; asc CPQC240924-02031;;
7: len 5; hex 99b4729150; asc r P;;
8: len 8; hex 8000000000000d03; asc ;;
9: len 5; hex 99b4729150; asc r P;;
10: len 8; hex 8000000000000d03; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 63 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035378; asc Sx;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c404a3; asc ;;
3: len 8; hex 800000000245cb8a; asc E ;;
4: len 8; hex 8000008bb30b03fe; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 595053513230323430393234303030323135; asc YPSQ20240924000215;;
7: len 5; hex 99b47295b9; asc r ;;
8: len 8; hex 8000000000006332; asc c2;;
9: len 5; hex 99b472959a; asc r ;;
10: len 8; hex 8000000000006332; asc c2;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 64 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035379; asc Sy;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c404b2; asc ;;
3: len 8; hex 800000000245cba2; asc E ;;
4: len 8; hex 8000008bb30b040c; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 16; hex 435051433234303932332d3030303931; asc CPQC240923-00091;;
7: len 5; hex 99b47296d4; asc r ;;
8: len 8; hex 8000000000003aee; asc : ;;
9: len 5; hex 99b47296b4; asc r ;;
10: len 8; hex 8000000000003aee; asc : ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 65 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003537a; asc Sz;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c404c1; asc ;;
3: len 8; hex 800000000245cbad; asc E ;;
4: len 8; hex 80000017e3a231b3; asc 1 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 14; hex 4b4c313031333035373035353031; asc KL101305705501;;
7: len 5; hex 99b4729769; asc r i;;
8: len 8; hex 8000000000004c31; asc L1;;
9: len 5; hex 99b4729769; asc r i;;
10: len 8; hex 8000000000004c31; asc L1;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 67 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003537c; asc S|;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c404df; asc ;;
3: len 8; hex 800000000245cc84; asc E ;;
4: len 8; hex 8000001ceae5cc9c; asc ;;
5: len 8; hex 8000000000000154; asc T;;
6: SQL NULL;
7: len 5; hex 99b472a137; asc r 7;;
8: len 8; hex 8000000000006195; asc a ;;
9: len 5; hex 99b472a136; asc r 6;;
10: len 8; hex 8000000000006195; asc a ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 68 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003537d; asc S};;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c404ee; asc ;;
3: len 8; hex 800000000245cc96; asc E ;;
4: len 8; hex 8000008bb30b047a; asc z;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 4350514359503234303932352d3030333432; asc CPQCYP240925-00342;;
7: len 5; hex 99b472a274; asc r t;;
8: len 8; hex 80000000000066a2; asc f ;;
9: len 5; hex 99b472a25b; asc r [;;
10: len 8; hex 80000000000066a2; asc f ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 69 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003537e; asc S~;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c404fd; asc ;;
3: len 8; hex 800000000245ccbf; asc E ;;
4: len 8; hex 8000001bf694c3a2; asc ;;
5: len 8; hex 8000000000000053; asc S;;
6: len 16; hex 435051433234303932342d3030393034; asc CPQC240924-00904;;
7: len 5; hex 99b472a42e; asc r .;;
8: len 8; hex 800000000000422f; asc B/;;
9: len 5; hex 99b472a42d; asc r -;;
10: len 8; hex 800000000000422f; asc B/;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 70 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003537f; asc S ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4050c; asc ;;
3: len 8; hex 800000000245ccfd; asc E ;;
4: len 8; hex 8000002546b85303; asc %F S ;;
5: len 8; hex 8000000000000057; asc W;;
6: len 14; hex 4b4c313032333032343339333537; asc KL102302439357;;
7: len 5; hex 99b472a759; asc r Y;;
8: len 8; hex 8000000000004eeb; asc N ;;
9: len 5; hex 99b472a759; asc r Y;;
10: len 8; hex 8000000000004eeb; asc N ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 71 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035380; asc S ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4051b; asc ;;
3: len 8; hex 800000000245d542; asc E B;;
4: len 8; hex 8000001c6dc3cc9f; asc m ;;
5: len 8; hex 8000000000000078; asc x;;
6: len 18; hex 595053513230323430393234303030323439; asc YPSQ20240924000249;;
7: len 5; hex 99b472ac39; asc r 9;;
8: len 8; hex 8000000000006529; asc e);;
9: len 5; hex 99b472ac39; asc r 9;;
10: len 8; hex 8000000000006529; asc e);;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 72 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035381; asc S ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c4052a; asc *;;
3: len 8; hex 800000000245cb82; asc E ;;
4: len 8; hex 8000001bf694c36d; asc m;;
5: len 8; hex 8000000000000053; asc S;;
6: len 16; hex 435051433234303932312d3031343230; asc CPQC240921-01420;;
7: len 5; hex 99b4729536; asc r 6;;
8: len 8; hex 800000000000582e; asc X.;;
9: len 5; hex 99b4729536; asc r 6;;
10: len 8; hex 800000000000582e; asc X.;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 73 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035382; asc S ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40539; asc 9;;
3: len 8; hex 800000000245ccdb; asc E ;;
4: len 8; hex 8000001c6dc3cc92; asc m ;;
5: len 8; hex 8000000000000078; asc x;;
6: len 16; hex 435051433234303932312d3031323835; asc CPQC240921-01285;;
7: len 5; hex 99b472a558; asc r X;;
8: len 8; hex 8000000000003c53; asc <S;;
9: len 5; hex 99b472a557; asc r W;;
10: len 8; hex 8000000000003c53; asc <S;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 74 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035383; asc S ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40548; asc H;;
3: len 8; hex 800000000245d4ff; asc E ;;
4: len 8; hex 8000008bb30b04d6; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 16; hex 435051433234303932332d3032323435; asc CPQC240923-02245;;
7: len 5; hex 99b472a9ef; asc r ;;
8: len 8; hex 800000000000166c; asc l;;
9: len 5; hex 99b472a9c3; asc r ;;
10: len 8; hex 800000000000166c; asc l;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 75 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 000000035384; asc S ;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40557; asc W;;
3: len 8; hex 800000000245d501; asc E ;;
4: len 8; hex 8000008bb30b04d9; asc ;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 4350514359503234303932352d3030373838; asc CPQCYP240925-00788;;
7: len 5; hex 99b472aa27; asc r ';;
8: len 8; hex 8000000000001320; asc ;;
9: len 5; hex 99b472a9f0; asc r ;;
10: len 8; hex 8000000000001320; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
Record lock, heap no 151 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000035372; asc Sr;;
1: len 6; hex 00000000bee3; asc ;;
2: len 7; hex 02000001170bed; asc ;;
3: len 8; hex 800000000245d52e; asc E .;;
4: len 8; hex 800000beebd01f79; asc y;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 18; hex 595053513230323430393132303030303131; asc YPSQ20240912000011;;
7: len 5; hex 99b4b892c7; asc ;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472ab86; asc r ;;
10: len 8; hex 8000000000006529; asc e);;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: len 6; hex 4e3030313531; asc N00151;;
Record lock, heap no 152 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000035348; asc SH;;
1: len 6; hex 00000000cd4d; asc M;;
2: len 7; hex 010000015f18d2; asc _ ;;
3: len 8; hex 800000000245d543; asc E C;;
4: len 8; hex 80000017dd7a7f2c; asc z ,;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030363430; asc CPQC240925-00640;;
7: len 5; hex 99b4bc703a; asc p:;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472ac45; asc r E;;
10: len 8; hex 80000000000063f1; asc c ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: len 6; hex 4e3030343139; asc N00419;;
Record lock, heap no 153 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 00000003537b; asc S{;;
1: len 6; hex 00000000d25b; asc [;;
2: len 7; hex 02000001b603ab; asc ;;
3: len 8; hex 800000000245cc7a; asc E z;;
4: len 8; hex 8000008bb30b046e; asc n;;
5: len 8; hex 8000000000000051; asc Q;;
6: len 16; hex 435051433234303931382d3030393639; asc CPQC240918-00969;;
7: len 5; hex 99b4bcfc40; asc @;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472a09d; asc r ;;
10: len 8; hex 8000000000000af2; asc ;;
11: len 8; hex 8000000010664d1c; asc fM ;;
12: SQL NULL;
13: len 6; hex 4e3030303033; asc N00003;;
Record lock, heap no 154 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000035340; asc S@;;
1: len 6; hex 0000000197a3; asc ;;
2: len 7; hex 0200000237081c; asc 7 ;;
3: len 8; hex 800000000245d505; asc E ;;
4: len 8; hex 800000566748ab63; asc VgH c;;
5: len 8; hex 8000000000000246; asc F;;
6: len 18; hex 485451433230323430393133303030323032; asc HTQC20240913000202;;
7: len 5; hex 99b53f1028; asc ? (;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472aa12; asc r ;;
10: len 8; hex 8000000000001b68; asc h;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: len 6; hex 4e3030323932; asc N00292;;
Record lock, heap no 155 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000035344; asc SD;;
1: len 6; hex 000000019998; asc ;;
2: len 7; hex 01000002041f09; asc ;;
3: len 8; hex 800000000245cccb; asc E ;;
4: len 8; hex 80000017e3a232bf; asc 2 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 18; hex 485451433230323430373038303030343133; asc HTQC20240708000413;;
7: len 5; hex 99b5847126; asc q&;;
8: len 8; hex 8000000000004429; asc D);;
9: len 5; hex 99b472a4a2; asc r ;;
10: len 8; hex 8000000000004429; asc D);;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: len 6; hex 4e3030303037; asc N00007;;
Record lock, heap no 156 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000035347; asc SG;;
1: len 6; hex 00000001ffce; asc ;;
2: len 7; hex 01000001d70686; asc ;;
3: len 8; hex 800000000245d541; asc E A;;
4: len 8; hex 80000017e3a23389; asc 3 ;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932352d3030353933; asc CPQC240925-00593;;
7: len 5; hex 99b5d471b5; asc q ;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472ac37; asc r 7;;
10: len 8; hex 8000000000000b6a; asc j;;
11: len 8; hex 80000000103c96bb; asc < ;;
12: SQL NULL;
13: len 6; hex 4e3030303034; asc N00004;;
Record lock, heap no 157 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 00000003536f; asc So;;
1: len 6; hex 0000000211a5; asc ;;
2: len 7; hex 01000001c02db4; asc - ;;
3: len 8; hex 800000000245d52a; asc E *;;
4: len 8; hex 80000017e3a2336e; asc 3n;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3030323534; asc CPQC240924-00254;;
7: len 5; hex 99b5dcab8f; asc ;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472ab69; asc r i;;
10: len 8; hex 8000000000000b89; asc ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: len 6; hex 4e3030313138; asc N00118;;
Record lock, heap no 158 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000035370; asc Sp;;
1: len 6; hex 0000000211a5; asc ;;
2: len 7; hex 01000001c02de7; asc - ;;
3: len 8; hex 800000000245d52b; asc E +;;
4: len 8; hex 80000017e3a23370; asc 3p;;
5: len 8; hex 80000000000002cf; asc ;;
6: len 16; hex 435051433234303932342d3030323534; asc CPQC240924-00254;;
7: len 5; hex 99b5dcab8f; asc ;;
8: len 8; hex 800000000000045b; asc [;;
9: len 5; hex 99b472ab6f; asc r o;;
10: len 8; hex 8000000000000b89; asc ;;
11: len 8; hex 80000000104d61e5; asc Ma ;;
12: SQL NULL;
13: len 6; hex 4e3030313138; asc N00118;;
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 103 page no 13321 n bits 184 index GEN_CLUST_INDEX of table `apps`.`oe_order_headers` trx id 136829 lock_mode X waiting
Record lock, heap no 105 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000333f4b; asc 3?K;;
1: len 6; hex 00000002167f; asc ;;
2: len 7; hex 81000000920110; asc ;;
3: len 8; hex 8000000000534248; asc SBH;;
4: len 8; hex 8000008bb2e80e7d; asc };;
5: len 8; hex 8000000000000051; asc Q;;
6: len 14; hex 312d313836343435343931303436; asc 1-186445491046;;
7: len 5; hex 99b5e07095; asc p ;;
8: len 8; hex 8000000000000000; asc ;;
9: len 5; hex 99a330ce9b; asc 0 ;;
10: len 8; hex 8000000000001170; asc p;;
11: len 8; hex 8000000004378d24; asc 7 $;;
12: SQL NULL;
13: len 6; hex 4e3030323739; asc N00279;;
*** (2) TRANSACTION:
TRANSACTION 136831, ACTIVE 36 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 38
MySQL thread id 5524, OS thread handle 20788, query id 4810643 localhost 127.0.0.1 hibuser updating
UPDATE apps.oe_order_headers
SET ORDER_NUMBER = 301600001072
, ORG_ID = 239
, CUST_PO_NUMBER = '1-182554692121'
, LAST_UPDATE_DATE = '2025-02-16 07:02:21.0'
, LAST_UPDATED_BY = 0
, CREATION_DATE = '2018-07-07 14:22:58.0'
, CREATED_BY = 4996
, LAST_UPDATE_LOGIN = 55671211
, attribute1 = 'N00248'
WHERE ( ( header_id = 4263767 ) )
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 103 page no 13321 n bits 184 index GEN_CLUST_INDEX of table `apps`.`oe_order_headers` trx id 136831 lock_mode X locks rec but not gap
Record lock, heap no 105 PHYSICAL RECORD: n_fields 14; compact format; info bits 64
0: len 6; hex 000000333f4b; asc 3?K;;
1: len 6; hex 00000002167f; asc ;;
2: len 7; hex 81000000920110; asc ;;
3: len 8; hex 8000000000534248; asc SBH;;
4: len 8; hex 8000008bb2e80e7d; asc };;
5: len 8; hex 8000000000000051; asc Q;;
6: len 14; hex 312d313836343435343931303436; asc 1-186445491046;;
7: len 5; hex 99b5e07095; asc p ;;
8: len 8; hex 8000000000000000; asc ;;
9: len 5; hex 99a330ce9b; asc 0 ;;
10: len 8; hex 8000000000001170; asc p;;
11: len 8; hex 8000000004378d24; asc 7 $;;
12: SQL NULL;
13: len 6; hex 4e3030323739; asc N00279;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 103 page no 5 n bits 224 index GEN_CLUST_INDEX of table `apps`.`oe_order_headers` trx id 136831 lock_mode X waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 14; compact format; info bits 0
0: len 6; hex 00000003533b; asc S;;;
1: len 6; hex 0000000021e9; asc ! ;;
2: len 7; hex 82000000c40110; asc ;;
3: len 8; hex 800000000245cd15; asc E ;;
4: len 8; hex 800000a33cd36e69; asc < ni;;
5: len 8; hex 80000000000000ea; asc ;;
6: len 16; hex 435051433234303931392d3030323436; asc CPQC240919-00246;;
7: len 5; hex 99b472a854; asc r T;;
8: len 8; hex 80000000000050cf; asc P ;;
9: len 5; hex 99b472a852; asc r R;;
10: len 8; hex 80000000000050cf; asc P ;;
11: len 8; hex 7fffffffffffffff; asc ;;
12: SQL NULL;
13: SQL NULL;
*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 138708
Purge done for trx's n:o < 138648 undo n:o < 0 state: running but idle
History list length 10
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283560905875664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283560905873336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283560905872560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 138707, ACTIVE 61 sec fetching rows
mysql tables in use 1, locked 0
7051 lock struct(s), heap size 860280, 987306 row lock(s), undo log entries 31
MySQL thread id 5809, OS thread handle 9152, query id 5175451 localhost 127.0.0.1 hibuser executing
SELECT HEADER_ID, ORDER_NUMBER, ORG_ID, CUST_PO_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, attribute1 FROM apps.oe_order_headers WHERE ( ( header_id = 38190737 ) )
Trx read view will not see trx with id >= 138707, sees < 138707
--------
FILE I/O
--------
I/O thread 0 state: wait Windows aio ((null))
I/O thread 1 state: wait Windows aio (insert buffer thread)
I/O thread 2 state: wait Windows aio (read thread)
I/O thread 3 state: wait Windows aio (read thread)
I/O thread 4 state: wait Windows aio (read thread)
I/O thread 5 state: wait Windows aio (read thread)
I/O thread 6 state: wait Windows aio (write thread)
I/O thread 7 state: wait Windows aio (write thread)
I/O thread 8 state: wait Windows aio (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:
Pending flushes (fsync) log: 0; buffer pool: 0
1305170 OS file reads, 4142373 OS file writes, 2443870 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 2.14 writes/s, 2.14 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 1757, seg size 1759, 508989 merges
merged operations:
insert 1533878, delete mark 230335, delete 26610
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 0 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
0.00 hash searches/s, 0.11 non-hash searches/s
---
LOG
---
Log sequence number 8445664913
Log buffer assigned up to 8445664913
Log buffer completed up to 8445664913
Log written up to 8445664913
Log flushed up to 8445664913
Added dirty pages up to 8445664913
Pages flushed up to 8445664798
Last checkpoint at 8445664798
Log minimum file id is 2569
Log maximum file id is 2579
1124428 log i/o's done, 0.56 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 1321060
Buffer pool size 8191
Free buffers 1023
Database pages 7109
Old database pages 2604
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5887685202, not young 28123529
7147.72 youngs/s, 0.00 non-youngs/s
Pages read 1305143, created 31346, written 2203934
0.00 reads/s, 0.00 creates/s, 0.82 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 3 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7109, unzip_LRU len: 0
I/O sum[45]:cur[2], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Process ID=5436, Main thread ID=8088 , state=sleeping
Number of rows inserted 912582, updated 282443, deleted 2, read 990874113312
0.00 inserts/s, 0.44 updates/s, 0.00 deletes/s, 2059900.34 reads/s
Number of system rows inserted 25, updated 473, deleted 8, read 40786
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
这些内容 读不懂怎么办呢?
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· 2 本地部署DeepSeek模型构建本地知识库+联网搜索详细步骤
2020-02-18 EBS: OM-Line:Schedule_ship_date不能輸入2021年的日期