Help Center/ Relational Database Service/ User Guide (ME-Abu Dhabi Region) / Working with RDS for MySQL/ Log Management/ Viewing and Downloading Error Logs
Updated on 2023-07-06 GMT+08:00
View PDF
Share

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 contain logs generated during the database running. These can help you analyze problems with the database. You can also download error logs for service analysis.

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 Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. In the navigation pane on the left, choose Logs. On the Error Logs page, view details about error logs.

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

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

      • ALL
      • ERROR
      • WARNING
      • NOTE
    • You can click in the upper right corner to view error 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 a Log

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Instance Management 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.

    • The system automatically loads the downloading preparation tasks. The loading duration is determined by the log file size and network environment.
      • During the downloading preparation, the log status is Preparing.
      • After the downloading preparation is complete, the log status is Preparation completed.
      • If the downloading preparation fails, the log status is Abnormal.

      Logs in the Preparing or Abnormal status cannot be downloaded.

    • 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 download the log, click OK.

Parent topic: Log Management