How to disable the slow query log to improve migration performance - Data Transmission Service

Disabling slow query logs on the destination ApsaraDB RDS for MySQL instance can improve data migration performance. We recommend this approach if the destination instance has a low specification, such as less than two CPU cores, and you want to migrate a large volume of data.

Prerequisites

The destination ApsaraDB RDS for MySQL instance runs MySQL 5.6, 5.7, or 8.0.

Background information

When Data Transmission Service (DTS) migrates data to the destination ApsaraDB RDS for MySQL instance, a large number of slow query logs are generated. The slow query log collection program scans and queries the slow query log tables, which increases the CPU load of the instance and degrades migration performance.

Procedure

Go to the Instances page in the ApsaraDB RDS console.
In the top navigation bar, select the region in which the destination ApsaraDB RDS for MySQL instance resides.
Find the destination instance and click Manage in the Actions column.
In the left-side navigation pane, click Parameter Settings.
Modify the value of the slow_query_log parameter.
1. On the Modifiable Parameters tab, find the slow_query_log parameter.
2. In the Parameter Value column, select OFF from the drop-down list.
3. At the top of the page, click Apply Changes.
4. In the Modify Parameters dialog box, select a time for the change to take effect.
  
  Note
  For more information, see Modify instance parameters.
5. Click OK.
Optional. After the data migration task is complete, you can change the running value of the slow_query_log parameter to ON.