Skip to main content
Question

Is it normal for tuple_mover_operations DVMerge occured frequently?

  • October 15, 2020
  • 3 replies
  • 9 views
HyeontaeJu
Forum|alt.badge.img+2

Is it normal for tuple_mover_operations DVMerge occured frequently?

operation_start_timestamp node_name operation_name operation_status table_schema table_name projection_name projection_id column_id earliest_container_start_epoch latest_container_end_epoch ros_count total_ros_used_bytes plan_type session_id transaction_id is_executing runtime_priority
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Start newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35338836 35831926 1 22132 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Complete newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35338836 35831926 1 22132 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Start newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35417094 35872136 2 24417 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Complete newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35417094 35872136 2 24417 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Abort newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 0 35877673 1 0 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Start newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35386698 35872136 2 57179 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Complete newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35386698 35872136 2 57179 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Start newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35471343 35872136 2 52758 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Complete newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35471343 35872136 2 52758 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Start newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35505598 35872136 2 55406 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Complete newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35505598 35872136 2 55406 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Start newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35532154 35872136 2 128309 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout Complete newbiz_product ws_product_brand_map ws_product_brand_map_DBD_2_rep_wshop_brand_b0 45035997737876332 0 35532154 35872136 2 128309 DVMergeout v_epdb_node0003-164843:0x41e1ba2 54043195666267104 false HIGH
2020-10-15 15:22:11 v_epdb_node0003 DVMergeout

    3 replies

    Sudhakar_B
    Forum|alt.badge.img+1
    • Sudhakar_B
    • Participating Frequently
    • December 31, 2020

    @HyeontaeJu
    Your data is unreadable!
    Short answer to your question Yes , if you have too many frequent small deletes that is creating "small size" DVROS, then DVMerge would kick in.
    Not the best-practice implementation, though.
    Would you be able to share more details on what else is going on in your cluster? That would help!

    Nimmi_gupta
    Forum|alt.badge.img
    • Nimmi_gupta
    • Participating Frequently
    • January 4, 2021

    @HyeontaeJu
    Can you check the default setting for the MaxDVROSPerContainer.
    Run the below query.
    select get_config_parameter('MaxDVROSPerContainer');

    When DVMergeout get triggered?
    When Maximum number of DVROSes attached to a single ROS container reached to the setting dv merge out happens.

    Nimmi_gupta
    Forum|alt.badge.img
    • Nimmi_gupta
    • Participating Frequently
    • January 4, 2021

    @HyeontaeJu
    In case if you interested in knowing about next eligible for dv mergeout, you can use the function call print_next_mergeout_job.
    select print_next_mergeout_job();

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement