This topic describes how to manage the logs of an RDS for MariaDB instance in the RDS console.

View logs

  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 MariaDB instance.) Similar SQL statements are displayed once only.
    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 MariaDB instance.)
    Primary/Secondary Instance Switch Log Records logs related to the switchovers between the master and slave instances within the last one month.