All Products
Search

This Product

    Data Transmission Service:View hotspot table information

    Document Center

    Data Transmission Service:View hotspot table information

    Last Updated:Jun 21, 2026

    In data synchronization and migration tasks, tables with frequent data changes (known as hotspot tables) may cause task latency to exceed 1,000 ms. You can view hotspot table information in the console to determine if hotspot tables are causing the latency. If so, you can enable the hot data merging feature to reduce task latency.

    Prerequisites

    • You have created a data synchronization or migration instance.

    • If you use a migration instance, the task must include Incremental Data Migration.

    Usage notes

    You will see the latest hotspot table information only after incremental data synchronization or migration begins and the task's checkpoint updates.

    Procedure

    Note

    The steps to view hotspot table information are similar for data synchronization and data migration instances. This topic uses a data synchronization instance as an example.

    1. Go to the data synchronization task list page in the destination region. You can do this in one of two ways.

      DTS console

      1. Log on to the DTS console.

      2. In the navigation pane on the left, click Data Synchronization.

      3. In the upper-left corner of the page, select the region where the synchronization instance is located.

      DMS console

      Note

      The actual steps may vary depending on the mode and layout of the DMS console. For more information, see Simple mode console and Customize DMS console layout and style.

      1. Log on to the DMS console.

      2. In the top menu bar, choose Data + AI > DTS (DTS) > Data Synchronization.

      3. To the right of Data Synchronization Tasks, select the region of the synchronization instance.

    2. On the synchronization task list page, click the ID of the target instance.

    3. Optional: In the navigation pane on the left, click Task Management.

    4. In the Progress section, click the Incremental Write module.

    5. On the Basic Information tab, view the Hotspot Table Information.

      The Hotspot Table Information section identifies data with the most frequent pending changes at the destination. It shows current information if incremental changes are in progress; otherwise, it shows the most recent hotspot table information.

      • Database Name: The name of the database that contains the data.

      • Table Name: The name of the table that contains the data.

      • Hot key: The value of the primary key or unique key for the data.

        Note

        This value helps you identify the data that is pending changes in the hotspot table.

      • Hot spot degree (conflict depth): The number of pending incremental changes for the data. The value is 1 or greater.

        Note

        If the Hot spot degree is greater than 10 and the task latency exceeds 1,000 ms (1 second), we recommend that you enable the hot data merging feature to reduce task latency and improve data write speed. For instructions, see Next steps.

    Next steps

    Note

    After you enable the hot data merging feature, DTS merges multiple UPDATE operations on the same row from the source database and executes only the final UPDATE operation when writing data to the destination. This results in fewer binlog records in the destination database than in the source. If your business requires complete binlog records, enable this feature with caution.

    1. Click the Parameter Settings tab.

    2. Find the row where the Parameter Name is trans.hot.merge.enable and click the 编辑 icon in the Parameter Value column.

    3. In the Modify Parameters dialog box, change the parameter value to true and click the Apply Changes button.

    4. Click OK.

      Note

      The parameter value for trans.hot.merge.enable changes to true, and a (Not yet take effect) message appears.

    5. Click 提交参数.

    6. In the Apply Changes dialog box, click OK. When a message appears indicating that the module will restart, click OK again.

      Note

      Currently, only the Take Effect Immediately option is supported, and it is selected by default.

    7. Click the Refresh icon 刷新 above the Incremental Write module.

      When the Incremental Write module is Running, the parameter value of trans.hot.merge.enable is true, and no (Not yet take effect) prompt is displayed, the hot data merging feature is enabled successfully.