Data Transmission Service:View hot data

Prerequisites

• A data synchronization or migration instance is purchased and configured.

• For a data migration instance, Incremental Data Migration is selected as a migration type.

Usage notes

The latest information about hot data in the destination database is displayed only after the incremental data of source tables is synchronized or migrated to destination tables and the consumption checkpoint of incremental data synchronization or migration is updated.

Procedure

1. Go to the Data Synchronization Tasks page.
   1. Log on to the Data Management (DMS) console.
   2. In the top navigation bar, click DTS.
   3. In the left-side navigation pane, choose DTS (DTS) > Data Synchronization.
   Note

   • Operations may vary based on the mode and layout of the DMS console. For more information, see Simple mode and Configure the DMS console based on your business requirements.
   • You can also go to the Data Synchronization Tasks page of the new DTS console.
2. From the drop-down list to the right of Data Synchronization Tasks, select the region in which the data synchronization instance resides.
   Note If you use the new DTS console, you must select the region in which the data synchronization instance resides in the top navigation bar.

3. On the Data Synchronization page, click the ID of your DTS instance.

4. Optional:In the left-side pane, click Task Management.

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

6. On the Basic Information tab, view the value of the Hotspot Table Information parameter.

   Note

   • The Hotspot Table Information parameter displays the data that is most frequently changed in the destination database of the current DTS task. The data entry is displayed in the format of Database name.Table name:pk,uk:Conflict depth. Where, pk indicates the value of the primary key in the data entry, and uk indicates the value of the unique key in the data entry. The comma (,) indicates that either pk or uk is displayed. The conflict depth indicates the number of times that incremental changes are to be performed on the data entry. The value of the conflict depth is greater than or equal to 1.

   • If the destination database has ongoing incremental data changes, the information about the current hot data entry is displayed. If the destination database does not have ongoing incremental data changes, the information about the latest hot data entry is displayed.

   If the value of the conflict depth is greater than 10, we recommend that you enable the hot data merging feature to prevent a high latency of the DTS task. For more information about how to enable the feature, see the What to do next section of this topic.

What to do next

1. In the Progress section, click the Incremental Write module. Then, click the Parameter Settings tab.

2. Find the trans.hot.merge.enable parameter and click the icon in the Parameter Value column.

3. In the Modify Parameters dialog box, change the parameter value to true.

4. Click OK.

   Note

   The value of the trans.hot.merge.enable parameter is changed to true in the Parameter Value column, and (Not yet take effect) is displayed next to the value.

5. Click .

6. In the Apply Changes message, click OK.

   Note By default, Take Effect Immediately is selected. This indicates that the parameter modifications take effect immediately.

7. Click the icon above the Incremental Write module.

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