Slow SQL queries significantly decrease the stability of a dedicated cluster. When issues such as high workloads and performance jitters occur on a dedicated cluster, administrators or developers can check whether slow query logs are generated.

Procedure

  1. Log on to the ApsaraDB MyBase console.
  2. In the upper-left corner of the page, select the region where you want to create a dedicated cluster.
  3. In the left-side navigation pane, click Clusters, find the dedicated cluster that you want to manage, and click Details in the Actions column.
  4. In the left-side navigation pane, click Instances. On the page that appears, find the instance that you want to manage.
  5. In the left-side navigation pane, choose Autonomy Service > Slow Query Logs.
    ss
    Note By default, the Slow Log Trend chart shows slow query logs within the latest 15 minutes. You can specify a time range and click Search to view the slow query logs within the specified time range. The maximum time range is one day.
  6. View the details of slow query logs by using one of the following methods:
    • Method 1
      1. Click the Slow Log Details tab below the Slow Log Trend chart.
      2. On the Slow Log Details tab, select the database that you want to query.
        Note If the requested content is hidden, you can move the pointer over the requested content and view the full requested content in the window that appears.
    • Method 2
      1. In the Slow Log Trend chart, click the point in time at which a slow query log is generated. On the Slow Log Statistics tab, view the details of the slow query log.
      2. On the Slow Log Statistics tab, click Sample in the Actions column. In the Slow Log Sample dialog box, view the details of the slow query log.
        Note If the requested content is hidden, you can move the pointer over the requested content and view the full requested content in the window that appears.