Disable slow query logs for an ApsaraDB RDS for MySQL instance to improve migration performance - Data Transmission Service

This topic describes how to disable slow query logs for a destination ApsaraDB RDS for MySQL instance to improve the performance of data migration. We recommend that you disable slow query logs 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 in the destination instance. The slow query log collection program of the destination ApsaraDB RDS for MySQL instance scans and queries the slow query log tables. As a result, the CPU load of the destination ApsaraDB RDS for MySQL instance increases. This compromises the performance of data migration.

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 Parameters.
Modify the value of the slow_query_log parameter.
1. On the Modifiable Parameters tab, find the slow_query_log parameter.
2. In the Running Value column of the parameter, select OFF from the drop-down list.
3. In the upper part 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.