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 slow query log collection component malfunctions.

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, and then specify a time range to view the log details.

   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 deduplicated.

   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 csvlog file content and stores it on a log server. Modify the rds_max_log_files parameter to adjust the maximum number of retained csvlog files. More csvlog files extend the queryable time range but consume more storage.

API reference