Help Center> Relational Database Service> User Guide> Working with RDS for MySQL> Log Management> Viewing and Downloading Error Logs
Updated on 2024-04-03 GMT+08:00
View PDF

Viewing and Downloading Error Logs

RDS log management allows you to view database-level logs, including error logs and slow SQL query logs.

Error logs help you analyze problems with databases. You can download error logs for further analysis.

You can view error logs generated within the last month.

Viewing Log Details

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance.
  5. In the navigation pane on the left, choose Logs. On the Error Logs page, click Log Details to view details about error logs.

    Figure 1 Error log details
    • You can select a log level in the upper right corner to view logs of the selected level.

      For RDS for MySQL DB instances, the following levels of logs are displayed:

      • All log levels
      • ERROR
      • WARNING
      • NOTE
    • A maximum of 2,000 error log records can be displayed. To view more error log records, contact customer service.
    • You can click in the upper right corner to view logs generated in different time segments.
    • If the description of a log is truncated, locate the log and move your pointer over the description in the Description column to view details.

Downloading an Error Log

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance.
  5. In the navigation pane on the left, choose Logs. On the Error Logs page, click Download. In the log list, locate a log whose status is Preparation completed and click Download in the Operation column.

    Figure 2 Downloading an error log
    • The system automatically loads the downloading preparation tasks. The loading duration is determined by the log file size and network environment.
      • When the log is being prepared for download, the log status is Preparing.
      • When the log is ready for download, the log status is Preparation completed.
      • If the preparation for download fails, the log status is Abnormal.

      Logs in the Preparing or Abnormal status cannot be downloaded.

    • If the size of a log to be downloaded is greater than 40 MB, you need to use OBS Browser+ to download it. For details, see Method 1: Using OBS Browser+.
    • The download link is valid for 5 minutes. After the download link expires, a message is displayed indicating that the download link has expired. If you need to redownload the log, click OK.
    • The downloaded logs contain only the logs of the primary node.

Enabling Error Log Reporting to LTS

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance name.
  5. In the navigation pane, click Logs. On the Error Logs page, click Log Details.
  6. Click next to Report Error Logs to LTS.
  7. Select an LTS log group and log stream and click OK.

    Figure 3 Enabling error log reporting to LTS

Parent topic: Log Management