All Products
Search

This Product

    Database Autonomy Service:Quick transaction analysis

    Document Center

    Database Autonomy Service:Quick transaction analysis

    Last Updated:Dec 04, 2025

    The quick transaction analysis feature displays the start and end statements of a transaction that includes a specific SQL statement. This lets you determine whether the transaction was committed or rolled back.

    Function introduction

    This feature uses hot storage data from DAS Enterprise Edition V3 or Compliance Edition to analyze the start and end statements of a transaction. This analysis reveals the commit or rollback status of the SQL statement that you selected.

    image

    Note

    • A quick transaction analysis task analyzes only the thread of the target SQL statement.

    • The analysis covers only 10 minutes of data: 5 minutes before and 5 minutes after the target SQL statement runs.

    • The analysis result shows only the transaction that contains the target SQL statement. This includes the transaction start statement (if it is within the 5-minute period before the target statement), the target SQL statement, and the transaction end statement (if it is within the 5-minute period after the target statement).

    Prerequisites

    • The target database engine is:

      • ApsaraDB RDS for MySQL

      • PolarDB for MySQL

    • The database instance is connected to DAS and its status is Accessed.

    • The database version and region support DAS Enterprise Edition V3 or Compliance Edition. For more information, see Editions and supported features.

    • DAS Enterprise Edition V3 or Compliance Edition is enabled for the instance. For more information, see DAS Enterprise Edition.

    Scenarios

    You can analyze the commit or rollback status of a target SQL statement using audit logs.

    Limits

    • This feature analyzes only SQL data stored within the hot storage period of DAS Enterprise Edition V3 or Compliance Edition.

      Note

      • To change the hot storage duration for DAS Enterprise Edition V3 or Compliance Edition, click Service Settings in the upper-right corner of the SQL Explorer and Audit page.

      • Hot storage incurs fees. For more information, see Billing details.

    • Rapid transaction analysis is only supported for updating SQL statements (INSERT, UPDATE, and DELETE).

    Procedure

    1. Log on to the DAS console.

    2. In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring.

    3. Find the target instance, click the instance ID, and then go to the instance details page.

    4. In the navigation pane on the left, click Request Analysis > SQL Explorer and Audit. Then, click the Audit tab.

      • Create a quick transaction analysis task

        Search for the required logs. In the log list, find the SQL statement that you want to analyze and click Quick Transaction Analysis in the Actions column.

      • View the transaction analysis results

        You can wait for the analysis results to appear on the current page. Alternatively, go to the Quick Transaction Analysis section of the SQL Explorer > Transaction Analysis page to view historical analysis tasks and their results.