ApsaraDB RDS:View logs

Usage notes

• Slow query log integrity: Under extreme conditions, slow query log records may be incomplete or lost:

  • The instance experiences performance bottlenecks.

  • The instance receives a high volume of SQL requests.

  • The component that collects slow query logs is malfunctioning.

View logs

1. Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the instance ID.

2. In the left-side navigation pane, click Logs.

3. On the Logs page, select Logs or Logs. Then, select a time range. The system displays the log details for the specified time period.

   Type	Description
   Error log	Records database errors from the last month.
   Slow query log details	Records SQL statements from the last 7 days that took more than 1 second to execute. Similar statements are de-duplicated.

   Note

   • For instances in the China (Zhangjiakou) region, only the error logs and slow query log details from the last 9 days are retained.

   • The system collects content from csvlog files in the database and saves it to a log server. To adjust the maximum number of retained csvlog files, you can modify the rds_max_log_files instance parameter. Retaining more csvlog files allows you to query a longer time range but consumes more storage space.

API reference