Help Center/ Data Admin Service/ User Guide/ TaurusDB/ Intelligent O&M/ SQL/ SQL Insights
Updated on 2025-11-24 GMT+08:00
View PDF
Share

SQL Insights

SQL Insights allows you to not only query all executed SQL statements, but also analyze and search for the tables that are accessed and updated most frequently, and the SQL statements with the longest lock wait, helping you quickly identify exceptions.

Usage Notes

  • You need to enable Collect All Query Logs before using SQL Insights. Collecting all SQL statements may cause less than 5% performance loss.
  • After Collect All Query Logs is disabled, new SQL statements will not be collected and the collected SQL data will be deleted.
  • All SQL statements are constrained by the memory buffer. When service volume is high, buffer overflow may result in dropped records.
  • Any SQL statement that exceeds the upper limit will be discarded by default.

    You can set rds_sql_tracer_max_record_size to specify the upper limit. For details, see Modifying Parameters of a TaurusDB Instance.

Procedure

  1. Log in to the console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane, choose Intelligent O&M > Instance List.

    Alternatively, on the Overview page, click Go to Intelligent O&M.

  5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
  6. Locate the target instance and click Details.
  7. Choose SQL > SQL Insights.

    If Collect All Query Logs is disabled, DAS cannot collect all SQL statements for analysis. You can click Log Settings and enable Collect All Query Logs.

    Figure 1 Configuring log settings

    Collect All Query Logs takes effect once it is enabled.

    To disable Collect All Query Logs, click Log Settings and toggle off the switch.

  8. Click Create Task. In the displayed dialog box, specify Time Range, Dimension, and other configuration items and click OK.

    Figure 2 Creating a task

  9. In the task list, view the SQL Insights task.

    Figure 3 Viewing a task
    • Locate the target task and click Details in the Operation column to view and export details about the SQL Insights task.
      1. Set SQL Type, Node, and Advanced Search. Click to export the task details.
        Figure 4 Task details

        A maximum of 10,000 records can be displayed. To view more, export the records.

      2. Click View Export List.
        Figure 5 View Export List
      3. Click Download to download all SQL details.
    • Locate your task and click View Syn Tasks in the Operation column to view synchronization task details.
      Figure 6 SQL Insights task synchronization list

Parent topic: SQL