This topic describes how to disable slow query log for a destination ApsaraDB RDS for MySQL instance to improve the performance of data migration. We recommend that you disable slow query log if the instance has a low specification (less than two CPU cores) and you want to migrate a large volume of data.

Prerequisites

The database version of ApsaraDB RDS for MySQL is 5.6, 5.7, or 8.0.

Background information

When migrating data to the destination ApsaraDB RDS for MySQL instance, DTS generates a large number of log entries in the instance. The log collection program of the instance scans and queries slow log tables. This increases the CPU load of the instance and compromises the performance of data migration.

Procedure

  1. Log on to the ApsaraDB for RDS console.
  2. In the upper-left corner of the page, select the region where the instance resides.
  3. Find the instance and click the instance ID.
  4. In the left-side navigation pane, click Parameters.
  5. Find the slow_query_log parameter, click the edit icon, set the parameter value to OFF, and then click Confirm.
    Disable slow query log
    Note After the data migration task is completed, you can set the value of the Slow_query_log parameter to ON.