You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/04/02 10:27:02 UTC
[GitHub] [shardingsphere] happyi opened a new issue #16569: Serious performance loss
happyi opened a new issue #16569:
URL: https://github.com/apache/shardingsphere/issues/16569
## Feature Request
the Serious performance loss like
```
2022-04-02 18:17:49.800 -DEBUG [main] { thread:main,datasource:master }- - [cn.mezeron.cloud.common.core.interceptor.DynamicDataSource:17]
Hibernate: insert into nx_order (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_Type, actual_paid_amt, appointment_id, backlog_comment, backlog_flag, befstati_by, belong_org_id, brand_type, collection_flag, comments, confirm_date, confirmed_amt, confirmed_by, current_paid_amt, customer_id, daily_closed, deduct_achievement_amt, emp_order_flag, ex_post_flag, exempt_sign, frist_consume_id, gift_amt, image_id, marketing_order_flag, order_num, order_type, order_type_code, org_ac_id, org_id, original_amt, paid_point, payable_amt, print_flag, rating, room_id, source, status, status_code, sub_type, sub_type_code, syncedFlag, unsigned_flag, unsigned_reason, use_amt, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2022-04-02 18:17:50.108 -DEBUG [main] { thread:main,datasource:master }- - [cn.mezeron.cloud.common.core.interceptor.DynamicDataSource:17]
Hibernate: insert into nx_order_item (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_amt_got, achievement_amt_remain, after_date, asset_id, backcase_Price, CartId, customer_id, delivery_status, item_desc, discount, giftAmt, gift_qty, instrument_id, order_id, parent_item_id, unit_price, product_id, promotion_group_id, promotionId, promotionLineId, qty, realAmt, real_price, replaced_id, replaced_product_id, return_price, reverse_record_id, shop_expert_name, shopIngredientCost, specType, status, status_code, synced_flag, prod_type, unit_point, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2022-04-02 18:17:50.225 - INFO [main] { 不分库分表耗时：436,orderId:fb1bb9dcd50f4911a5f036ea700480f8 }- - [ShardingTest:34]
2022-04-02 18:17:50.225 -DEBUG [main] { thread:main,datasource:sharding }- - [cn.mezeron.cloud.common.core.interceptor.DynamicDataSource:17]
Hibernate: insert into nx_order (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_Type, actual_paid_amt, appointment_id, backlog_comment, backlog_flag, befstati_by, belong_org_id, brand_type, collection_flag, comments, confirm_date, confirmed_amt, confirmed_by, current_paid_amt, customer_id, daily_closed, deduct_achievement_amt, emp_order_flag, ex_post_flag, exempt_sign, frist_consume_id, gift_amt, image_id, marketing_order_flag, order_num, order_type, order_type_code, org_ac_id, org_id, original_amt, paid_point, payable_amt, print_flag, rating, room_id, source, status, status_code, sub_type, sub_type_code, syncedFlag, unsigned_flag, unsigned_reason, use_amt, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2022-04-02 18:17:51.425 - INFO [main] { Logic SQL: insert into nx_order (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_Type, actual_paid_amt, appointment_id, backlog_comment, backlog_flag, befstati_by, belong_org_id, brand_type, collection_flag, comments, confirm_date, confirmed_amt, confirmed_by, current_paid_amt, customer_id, daily_closed, deduct_achievement_amt, emp_order_flag, ex_post_flag, exempt_sign, frist_consume_id, gift_amt, image_id, marketing_order_flag, order_num, order_type, order_type_code, org_ac_id, org_id, original_amt, paid_point, payable_amt, print_flag, rating, room_id, source, status, status_code, sub_type, sub_type_code, syncedFlag, unsigned_flag, unsigned_reason, use_amt, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }- - [org.apache.shardingsphere.infra.executor.sql.log.SQLLogger:74]
2022-04-02 18:17:51.426 - INFO [main] { SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty) }- - [org.apache.shardingsphere.infra.executor.sql.log.SQLLogger:74]
2022-04-02 18:17:51.427 - INFO [main] { Actual SQL: m1 ::: insert into nx_order_s0 (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_Type, actual_paid_amt, appointment_id, backlog_comment, backlog_flag, befstati_by, belong_org_id, brand_type, collection_flag, comments, confirm_date, confirmed_amt, confirmed_by, current_paid_amt, customer_id, daily_closed, deduct_achievement_amt, emp_order_flag, ex_post_flag, exempt_sign, frist_consume_id, gift_amt, image_id, marketing_order_flag, order_num, order_type, order_type_code, org_ac_id, org_id, original_amt, paid_point, payable_amt, print_flag, rating, room_id, source, status, status_code, sub_type, sub_type_code, syncedFlag, unsigned_flag, unsigned_reason, use_amt, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ::: [ylhmini-test, 1648894670253, ylhmini-test, 1648894670253, 0, 0.0,
null, 0.0, null, null, true, null, null, 生美店, true, null, null, 0.0, null, 0.0, 2d0b487e-c477-48ee-97f0-f2b5b9bbe509, false, 0.0, false, null, null, null, 0.0, null, false, 2d0b487e-c477-48ee-97f0-f2b5b9bbe509, 购买, 0, null, null, 0.0, 0.0, 0.0, false, 0, null, 分片测试, null, 0, 门店, 0, false, true, null, 0.0, 206223e0f6624e99bf26b6402ddbc823] }- - [org.apache.shardingsphere.infra.executor.sql.log.SQLLogger:74]
2022-04-02 18:17:51.594 -DEBUG [main] { thread:main,datasource:sharding }- - [cn.mezeron.cloud.common.core.interceptor.DynamicDataSource:17]
Hibernate: insert into nx_order_item (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_amt_got, achievement_amt_remain, after_date, asset_id, backcase_Price, CartId, customer_id, delivery_status, item_desc, discount, giftAmt, gift_qty, instrument_id, order_id, parent_item_id, unit_price, product_id, promotion_group_id, promotionId, promotionLineId, qty, realAmt, real_price, replaced_id, replaced_product_id, return_price, reverse_record_id, shop_expert_name, shopIngredientCost, specType, status, status_code, synced_flag, prod_type, unit_point, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2022-04-02 18:17:51.605 - INFO [main] { Logic SQL: insert into nx_order_item (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_amt_got, achievement_amt_remain, after_date, asset_id, backcase_Price, CartId, customer_id, delivery_status, item_desc, discount, giftAmt, gift_qty, instrument_id, order_id, parent_item_id, unit_price, product_id, promotion_group_id, promotionId, promotionLineId, qty, realAmt, real_price, replaced_id, replaced_product_id, return_price, reverse_record_id, shop_expert_name, shopIngredientCost, specType, status, status_code, synced_flag, prod_type, unit_point, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }- - [org.apache.shardingsphere.infra.executor.sql.log.SQLLogger:74]
2022-04-02 18:17:51.606 - INFO [main] { SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty) }- - [org.apache.shardingsphere.infra.executor.sql.log.SQLLogger:74]
2022-04-02 18:17:51.606 - INFO [main] { Actual SQL: m1 ::: insert into nx_order_item_s0 (created_by, created_time, updated_by, updated_time, version, achievement_amt, achievement_amt_got, achievement_amt_remain, after_date, asset_id, backcase_Price, CartId, customer_id, delivery_status, item_desc, discount, giftAmt, gift_qty, instrument_id, order_id, parent_item_id, unit_price, product_id, promotion_group_id, promotionId, promotionLineId, qty, realAmt, real_price, replaced_id, replaced_product_id, return_price, reverse_record_id, shop_expert_name, shopIngredientCost, specType, status, status_code, synced_flag, prod_type, unit_point, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ::: [ylhmini-test, 1648894671595, ylhmini-test, 1648894671595, 0, 0.0, 0.0, 0.0, null, null, 0.0, null, 2d0b487e-c477-48ee-97f0-f2b5b9bbe509, null, null, 1.0, 0.0, null, null, 206223e0f6624e99bf26b6402ddbc823, null,
null, null, null, null, null, null, 0.0, null, null, null, null, null, null, null, null, 新建, 0, false, null, null, 4ce7f4ac0dd04984a5dff3c0a0404be8] }- - [org.apache.shardingsphere.infra.executor.sql.log.SQLLogger:74]
2022-04-02 18:17:51.724 - INFO [main] { 分库分表总耗时：1499,orderId:206223e0f6624e99bf26b6402ddbc823 }- - [ShardingTest:42]
```
insert into order and order_item
not sharing time ：436ms sharing tiem 1499ms
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org