本帖最后由 马天艺 于 2023-8-24 10:03 编辑
现在还在kill 状态
show processlist
| 261789 | xxx_bi | x.x.x.x:53202 | order | Killed | 16892 | update | INSERT INTO DM_F_ORDER_DETAIL (`crm_order_id`, `crm_order_line_id`, `sales_order_id`, `sales_order_num`, `sales_order_line_id`, `order_date`, `order_year`, `order_month`, `dept_type`, `sales_order_type`, `dept`, `provinces`, `dept_level1`, `opp_num`, `opp_name`, `industry_level1`, `industry_level2`, `industry_level3`, `industry_level4`, `out_note`, `in_note`, `item_number`, `item_name`, `item_model`, `item_inmodel`, `product_line1`, `product_line2`, `product_line3`, `price`, `quantity`, `amount`, `prepare_quantity`, `shipped_quantity`, `order_line_status`, `is_sale`, `is_return_sale`, `provinces_bi`, `industry_fx`, `org_type`, `last_update_date`, `opp_id`, `order_booked_date`, `order_ou`, `is_present`, `customer_num_sold`, `customer_name_sold`, `product_line4`, `agree_num`, `industry_fx1`, `contract_amount`, `order_amount`, `order_booked_date_wid`, `created`, `subcompany_flg`, `transaction_date`, `business_module`, `item_insmb`, `fx_project`, `hd_flag`, `hd_price`, `hd_amount`, `external_remarks`, `primarycustomername`, `primarycustomercode`, `hc_flag`, `x_accnt_type`, `x_fx_sub_type`, `salesrep_num_xd`, `salesrep_name_xd`, `order_customer_province`, `order_customer_city`, `order_customer_area`, `prod_spec`, `prod_sub_series`) VALUES (null, null, null, '130753936719', '5.64224244E8', '2022-12-07 00:00:00', 2022, 202212, '国内', '10xxxx单', '国xxx中心-山东-xx务部-金x组', '山东', 'xx销中心', 'A6Bxx5002', '田家xxxxxx备注)', '金融', '中农工建', 'xxxx', '一级分行', null, null, '1.0.01.25.11496-0003', '1-CAELGQR(标签)国内xxxx主机（室xxx外-DH-ASxxx-CW-SL4', 'DH-xxx12H-W', 'DH-ASI2212H-CW-SL4', '智xxx', '门x', 'Axx系列', 975.799999999999954525264911353588104248046875, 1, 600, 1, 1, '已关闭', 'N', 'N', '山东', null, '浙xxxxxxx限公司', null, '1-xxxUR', '2022-12-07', '101', 'N', '201408260023', '中xxxxx限公xxx岛市分行', 'ASIxxx12H', '10122xx630044', '非分销', 600, 600, null, null, null, null, '产品', null, null, 'N', null, null, null, null, null, 'N', '甲方', null, '38570', '申全x.', '山东', '青x市', 'xxxx', null, null) |
| 144 | repl_user | prm_mysql02.dahuatech.com:39162 | NULL | Binlog Dump GTID | 366395 | Master has sent all binlog to slave; waiting for more updates | NULL
mysql> show engine innodb status \G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2023-08-24 09:59:23 0x7fd8ba8a3700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 221706 srv_active, 0 srv_shutdown, 144058 srv_idle
srv_master_thread log flush and writes: 365764
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4695426
OS WAIT ARRAY INFO: signal count 8305826
RW-shared spins 0, rounds 8726441, OS waits 1943847
RW-excl spins 0, rounds 106593904, OS waits 1310722
RW-sx spins 619330, rounds 16914405, OS waits 484869
Spin rounds per wait: 8726441.00 RW-shared, 106593904.00 RW-excl, 27.31 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 1808112430
Purge done for trx's n < 1808112428 undo n < 0 state: running but idle
History list length 26
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 422091232899088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232577152, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232924624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232920976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232881760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232794208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232914592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232907296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232735840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232478656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232663792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232662880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232830688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232524256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232499632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232900000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232548880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232865344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232925536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232601776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232908208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232578064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232891792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232869904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232645552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232862608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232828864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232923712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232922800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232651024, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232567120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232916416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232915504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232586272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232773232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232587184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232522432, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232771408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232874464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232921888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232462240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232906384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232920064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232919152, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232918240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232867168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232861696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232880848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232764112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232549792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232720336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232903648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232873552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232724896, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232892704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232912768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232911856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232910032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232707568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232859872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232902736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232606336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232901824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232897264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232868992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232900912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232893616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232884496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232898176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232894528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232886320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232879024, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232878112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232857136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232889968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232883584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232715776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232813360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232768672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232543408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232888144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232573504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232531552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232877200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232879936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232882672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232456768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232876288, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232821568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232791472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232705744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232560736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232504192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232863520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232634608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232848016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232838896, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232753168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232510576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232660144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232871728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232868080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232860784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232761376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232866256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232864432, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232622752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232473184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232843456, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232852576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232851664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232850752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232583536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232849840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232829776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232638256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232817008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232580800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232557088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232781440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232585360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232858960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232858048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232856224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232479568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232855312, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232854400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232848928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232847104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232826128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232846192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232841632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232845280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232844368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232837072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232842544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232702096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232494160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232603600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232508752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232836160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232840720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232806976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232574416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232699360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232831600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232630960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232839808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232664704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232701184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232833424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232822480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232611808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232537936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232823392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232832512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232810624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232716688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232776880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232734016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232518784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232756816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232564384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232637344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232553440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232730368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232597216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232758640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232594480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232465888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232816096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232805152, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232834336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232827952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232613632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232747696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232746784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232495984, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232749520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232576240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232818832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232677472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232542496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232641904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232751344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232738576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232727632, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232520608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232607248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232512400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232723072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232706656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232516048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232765024, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232825216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232731280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232685680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232517872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232659232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232584448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232471360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232800592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232636432, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232535200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232815184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232812448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232511488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232820656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232817920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232811536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232807888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232778704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232629136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232589008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232759552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232748608, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232647376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232550704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232798768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232789648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232546144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232514224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232785088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232561648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232589920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232579888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232667440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232696624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232539760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232558000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232544320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232640080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232786000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232806064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232804240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232796944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232809712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232808800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232802416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232754992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232799680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232536112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232624576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232796032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232787824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232769584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232670176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232505104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232519696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232795120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232700272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232703008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232763200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232744960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232604512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232780528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232779616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232775968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232775056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232733104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232582624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232682032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232562560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232757728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232755904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232752256, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232745872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232739488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232690240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232672912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232452208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232527904, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232680208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232568032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232565296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232516960, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232602688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232486864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232502368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232581712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232750432, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232599952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232464976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232728544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232713952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232732192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232718512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232649200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232623664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232793296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232792384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232790560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232737664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232782352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232599040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232774144, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232772320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232515136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232490512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232719424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232683856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232525168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232563472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232767760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232697536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232620928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232765936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232744048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232743136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232740400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232454032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232711216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232686592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232460416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232725808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232714864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232694800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232698448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232679296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232570768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232672000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232595392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232681120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232619104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232569856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232710304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232691152, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232653760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232631872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232620016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232545232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232665616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232521520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232661056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232461328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232650112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232648288, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232684768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232559824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232625488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232609072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232675648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232640992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232578976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232453120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232523344, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232709392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232704832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232682944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232669264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232626400, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232654672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232571680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232475008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232458592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232614544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232528816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232529728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232616368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232608160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232591744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232487776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232661968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232610896, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232590832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232643728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232609984, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232734928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232605424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232593568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232451296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232526992, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232786912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232658320, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232472272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232762288, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232723984, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232488688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232741312, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232722160, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232668352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232678384, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232598128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232713040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232695712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232692064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232783264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232633696, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232819744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232913680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232688416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232621840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232827040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232687504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232917328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232766848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232905472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232895440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232835248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232596304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232463152, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232708480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232814272, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232537024, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232526080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232742224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232493248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232784176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232671088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232974784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232853488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232988464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232673824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232987552, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232944688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232676560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232532464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232939216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232910944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232491424, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232632784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232729456, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232904560, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232870816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232896352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232674736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232837984, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232693888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232770496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232689328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232455856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232600864, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232803328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232777792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232554352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232457680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232454944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232630048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232717600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232712128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232646464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232469536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232476832, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232572592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232657408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232655584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232617280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232615456, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232547968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232551616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232506928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232588096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232627312, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232480480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232692976, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232555264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232533376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232721248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232797856, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232642816, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232652848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232639168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232909120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232754080, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232824304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232656496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232801504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232760464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232736752, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232468624, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232464064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232495072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232666528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232501456, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232513312, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232628224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232466800, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232538848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232507840, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232575328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232534288, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232703920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232489600, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232885408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232890880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232889056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232887232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232503280, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232875376, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232872640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232651936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232644640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232788736, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232635520, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232618192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232612720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232592656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232568944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232552528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232566208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232558912, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232556176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232541584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232540672, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232530640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232509664, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232500544, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232506016, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232498720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232497808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232496896, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232492336, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232477744, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232459504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232485952, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232485040, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232484128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232483216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232482304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232481392, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232475920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232474096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232470448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232467712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 422091232449472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 1807448515, ACTIVE 17110 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5843
MySQL thread id 261789, OS thread handle 140581621888768, query id 50576603 10.3.0.15 prm_bi update
INSERT INTO DM_F_ORDER_DETAIL (`crm_order_id`, `crm_order_line_id`, `sales_order_id`, `sales_order_num`, `sales_order_line_id`, `order_date`, `order_year`, `order_month`, `dept_type`, `sales_order_type`, `dept`, `provinces`, `dept_level1`, `opp_num`, `opp_name`, `industry_level1`, `industry_level2`, `industry_level3`, `industry_level4`, `out_note`, `in_note`, `item_number`, `item_name`, `item_model`, `item_inmodel`, `product_line1`, `product_line2`, `product_line3`, `price`, `quantity`, `amount`, `prepare_quantity`, `shipped_quantity`, `order_line_status`, `is_sale`, `is_return_sale`, `provinc
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (read thread)
I/O thread 7 state: waiting for completed aio requests (read thread)
I/O thread 8 state: waiting for completed aio requests (read thread)
I/O thread 9 state: waiting for completed aio requests (read thread)
I/O thread 10 state: waiting for completed aio requests (write thread)
I/O thread 11 state: waiting for completed aio requests (write thread)
I/O thread 12 state: waiting for completed aio requests (write thread)
I/O thread 13 state: waiting for completed aio requests (write thread)
I/O thread 14 state: waiting for completed aio requests (write thread)
I/O thread 15 state: waiting for completed aio requests (write thread)
I/O thread 16 state: waiting for completed aio requests (write thread)
I/O thread 17 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
24079835 OS file reads, 23385540 OS file writes, 5494962 OS fsyncs
1.37 reads/s, 16384 avg bytes/read, 24.37 writes/s, 2.37 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 123941, seg size 123943, 368729 merges
merged operations:
insert 338445, delete mark 1898792, delete 414663
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 7968299, node heap has 3234 buffer(s)
Hash table size 7968299, node heap has 7523 buffer(s)
Hash table size 7968299, node heap has 5872 buffer(s)
Hash table size 7968299, node heap has 2574 buffer(s)
Hash table size 7968299, node heap has 6878 buffer(s)
Hash table size 7968299, node heap has 4986 buffer(s)
Hash table size 7968299, node heap has 4262 buffer(s)
Hash table size 7968299, node heap has 4126 buffer(s)
55530.43 hash searches/s, 6484.19 non-hash searches/s
---
LOG
---
Log sequence number 2000278161820
Log flushed up to 2000278161820
Pages flushed up to 2000277536219
Last checkpoint at 2000277536219
0 pending log flushes, 0 pending chkp writes
4133873 log i/o's done, 2.38 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 32982958080
Dictionary memory allocated 5062331
Buffer pool size 1965960
Free buffers 8192
Database pages 1918313
Old database pages 707964
Modified db pages 3371
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 62955301, not young 116427407
64.99 youngs/s, 15.25 non-youngs/s
Pages read 24078499, created 1095504, written 18583675
1.37 reads/s, 0.00 creates/s, 22.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: 1918313, unzip_LRU len: 0
I/O sum[30096]:cur[152], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 245760
Free buffers 1024
Database pages 239804
Old database pages 88501
Modified db pages 417
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7843121, not young 16097753
7.62 youngs/s, 1.87 non-youngs/s
Pages read 3272839, created 138273, written 2476506
0.12 reads/s, 0.00 creates/s, 2.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: 239804, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 245730
Free buffers 1024
Database pages 239761
Old database pages 88485
Modified db pages 464
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7919311, not young 14987097
4.75 youngs/s, 4.87 non-youngs/s
Pages read 3161694, created 137713, written 2877306
0.25 reads/s, 0.00 creates/s, 2.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: 239761, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 245760
Free buffers 1024
Database pages 239788
Old database pages 88495
Modified db pages 487
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7931864, not young 14323068
6.37 youngs/s, 0.00 non-youngs/s
Pages read 3094552, created 136906, written 2267439
0.00 reads/s, 0.00 creates/s, 2.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: 239788, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 245730
Free buffers 1024
Database pages 239795
Old database pages 88498
Modified db pages 376
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7825777, not young 12924700
10.62 youngs/s, 1.75 non-youngs/s
Pages read 2193307, created 137006, written 2229188
0.37 reads/s, 0.00 creates/s, 2.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: 239795, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 245760
Free buffers 1024
Database pages 239831
Old database pages 88511
Modified db pages 437
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8684080, not young 12934623
11.87 youngs/s, 0.12 non-youngs/s
Pages read 1974490, created 136686, written 2205349
0.12 reads/s, 0.00 creates/s, 2.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: 239831, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 245730
Free buffers 1024
Database pages 239779
Old database pages 88492
Modified db pages 372
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7576172, not young 15224993
9.25 youngs/s, 0.25 non-youngs/s
Pages read 3523716, created 136492, written 2226844
0.25 reads/s, 0.00 creates/s, 2.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: 239779, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 245760
Free buffers 1024
Database pages 239796
Old database pages 88498
Modified db pages 369
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7769290, not young 14641048
9.37 youngs/s, 0.00 non-youngs/s
Pages read 3189034, created 135945, written 2162561
0.00 reads/s, 0.00 creates/s, 2.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: 239796, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 245730
Free buffers 1024
Database pages 239759
Old database pages 88484
Modified db pages 449
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7405686, not young 15294125
5.12 youngs/s, 6.37 non-youngs/s
Pages read 3668867, created 136483, written 2138482
0.25 reads/s, 0.00 creates/s, 2.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: 239759, unzip_LRU len: 0
I/O sum[3762]:cur[19], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=16934, Main thread ID=140582608799488, state: sleeping
Number of rows inserted 401659470, updated 4174279, deleted 817360, read 93059073914
222.47 inserts/s, 1.00 updates/s, 0.00 deletes/s, 209287.09 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set (0.00 sec) |
