SQL Explorer

Features

DAS integrates Search, SQL Explorer, Security Audit, and Traffic Replay and Stress Testing based on full request data collection. These features help you retrieve SQL details, troubleshoot performance issues, identify high-risk sources, and assess scaling needs.

• Search feature: Queries and exports SQL statements and related information such as database, status, and execution time. Audit.

  Note

  Enabling or disabling audit logs on the SQL Explorer and Audit console page changes thelog_statement kernel parameter.

  • Enabling audit logs setslog_statement = all.

  • Disabling audit logs setslog_statement = ddl.

• SQL Explorer: Diagnoses SQL health, troubleshoots performance issues, and analyzes service traffic. SQL Explorer.

  • SQL Review: Identifies suspicious SQL statements across database instances and provides optimization suggestions. SQL Review.

  • Traffic Replay and Stress Testing: Validates whether your instance specifications can handle traffic peaks. Traffic Replay and Stress Testing.

  • The Security audit feature identifies risks such as high-risk SQL, SQL injection, and new access sources. Security Audit.

  • The Transaction Analysis feature displays transaction types, counts, and details for a specific process within a time period, helping you analyze and optimize database performance. Transaction Analysis.

  • Quick Transaction Analysis: Identifies the start and end statements of a transaction to determine whether it was committed or rolled back. Quick Transaction Analysis.

Supported regions

SQL Explorer and Audit requires DAS Enterprise Edition. Supported regions vary by edition. Databases and regions supported by different editions.

Impact

SQL Explorer records all DQL, DML, and DDL operations. The data is output by the database kernel with minimal CPU overhead.

Usage notes

To use the Search feature, RAM users must have the AliyunPolardbReadOnlyWithSQLLogArchiveAccess permission. Create and manage RAM users.

Billing

Enable SQL Explorer

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. Enable SQL Explorer.

   If DAS Enterprise Edition is not enabled for your Alibaba Cloud account, follow the on-screen instructions to enable it.

6. Click a feature tab to view related information.

   • Range View: Select a time range to view the SQL Explorer results. You can view the Execution Time Distribution, Execution Duration, and Executions for all SQL statements within the selected time range. You can also view detailed information about all SQL statements in the Full Request Statistics section and export the information to your local computer.

     Note

     You can export a maximum of 1,000 SQL logs. To retrieve more SQL logs over a longer time range, you can use the Audit feature.

   • Display by Comparison: Select time points to compare the SQL Explorer results. You can view a comparison of the Execution Time Distribution, Execution Duration, and Executions for all SQL statements. You can also view detailed comparison results in the Requests by Comparison section.

   • Source Statistics: Select a time range to view statistics about SQL sources. You can view the source information for all SQL statements within the selected time range.

Modify the storage duration of SQL logs

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. In the upper-right corner, click Service Settings.

6. Modify the storage duration, and click OK.

   If you have enabled DAS Enterprise Edition V3, you can modify the data storage duration for different sub-features.

   Note

   The storage space for SQL Explorer data is provided by DAS and does not occupy the storage space of the database instance.

Export SQL records

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. Click the Audit tab, and then click Export.

6. In the dialog box that appears, select the required Export Field, specify an Export Time Range, and click OK.

7. In the Are you sure that you want to export SQL details? dialog box, set the Task Name and CSV Separator, and then click Are you sure you want to submit the task?.

   Note

   • Once a task is submitted, it cannot be canceled.

   • No fees are charged if the task fails.

   • Task-related data is retained for only 7 days.

   • A maximum of 10 million records can be exported for a task. If the number of records to export exceeds 10 million, you must reduce the time range for the export.

   • The system requires approximately 5 minutes to process and archive the latest data. To export the latest data, wait for a few minutes and then try again.

8. After the export is complete, click Tasks in the upper-right corner of the SQL Explorer page. In the Actions column of the target task, click Download to download the exported file.

Disable SQL Explorer

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. Click Service Settings to disable SQL Explorer and SQL Audit.

   If you have enabled DAS Enterprise Edition V3, clear the check boxes for all SQL Explorer and SQL Audit features, and then click Submit.

   Note

   Approximately one hour after you disable the SQL Explorer and SQL Audit features, the system releases the storage space that is occupied by the SQL Explorer and SQL Audit data.

6. Select the check box to acknowledge the prompt, and then click Submit and Unsubscribe.

View audit log size and consumption

1. Log on to the Alibaba Cloud Console. In the upper-right corner of the page, choose Expenses.

2. In the left-side Expenses and Costs navigation pane, choose Bill > Bill Details. View the cost details where the Billable Item column is sql_explorer.

3. On the Bill Details page, search by Instance ID. View the cost details where the Billable Item column is sql_explorer.