View hotspot table information

Prerequisites

• A data synchronization or migration instance is created.

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

Usage notes

The latest hotspot table information appears only after incremental data synchronization or migration begins and the task checkpoint updates.

Procedure

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.

   This section lists the data with the most frequent pending changes at the destination. If incremental changes are in progress, current hotspot data is shown; otherwise, the most recent hotspot table information is displayed.

   • Database Name: The database that contains the data.

   • Table Name: The table that contains the data.

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

     Note

     Use this value to identify the data 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

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.