This topic describes how to manage the error logs, slow query logs, and primary/secondary instance switching logs of an ApsaraDB RDS MariaDB instance through the ApsaraDB for RDS console.

Procedure

  1. Log on to the ApsaraDB for RDS console.
  2. In the upper-left corner of the console, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, click Logs.
  5. On the Logs page that appears, click the Error Log, Slow Query Log, Slow Query Log Summary, or Primary/Secondary Instance Switching Log tab, select a time range, and click Search.
    Tab Description
    Error Log Records database running errors that occurred within the last month.
    Slow Query Log Records SQL statements that each took more than 1 second to run within the last month. Duplicate SQL statements are deleted. You can change this 1-second threshold by reconfiguring the long_query_time parameter. For more information, see Reconfigure parameters for an RDS MariaDB instance.
    Slow Query Log Summary Provides statistics and analysis reports on SQL statements that each took more than 1 second to run within the last month. You can change this 1-second threshold by reconfiguring the long_query_time parameter. For more information, see Reconfigure parameters for an RDS MariaDB instance.
    Primary/Secondary Instance Switching Log Records switchovers between the primary and secondary instances triggered within the last month.