This topic describes how to manage logs through the RDS console or by using SQL statements. You can query error logs and slow query logs. The log query results help you to locate faults. All RDS for MySQL instances except those in the Basic Edition support log management.

Procedure

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Log Management.
  5. On the Log Management page, select Error Log, Slow Query Log, Slow Query Log Summary, or Primary/Secondary Instance Switch Log, select a time range, and click Search.
    Query item Description
    Error Log Records the SQL statements that are failed to be executed within the last one month.
    Slow Query Log Records the SQL statements that lasted for more than 1 second within the last one month. (You can reconfigure the long_query_time parameter to change this time threshold according to Reconfigure parameters for an RDS for MySQL instance.) Similar SQL statements are displayed once only.
    Note The slow query logs are updated in the console once every minute. You can view the mysql.slow_log table to obtain real-time slow query logs.
    Slow Query Log Summary Provides statistics and analysis reports for SQL statements that lasted for more than 1 second within the last one month. (You can reconfigure the long_query_time parameter to change this time threshold according to Reconfigure parameters for an RDS for MySQL instance.)
    Primary/Secondary Instance Switch Log Available to RDS instances in the MySQL High-availability Edition.
    Note For each RDS instance in the China (Zhangjiakou) region, the system retains only the error logs, slow query logs, and slow query log summary generated within the last nine days.