When a DML statement produces unexpected results, you need to know whether its enclosing transaction was committed or rolled back. Quick transaction analysis locates the transaction boundaries for a specific SQL statement, showing you the transaction start statement and the end statement (COMMIT or ROLLBACK).
How it works
Quick transaction analysis queries hot storage data from DAS Enterprise Edition V3 or Compliance Edition. It analyzes only the thread that ran the target statement, within a fixed 10-minute window centered on the statement's execution time.
The analysis result includes:
The transaction start statement, if it falls within 5 minutes before the target statement
The target SQL statement itself
The transaction end statement (COMMIT or ROLLBACK), if it falls within 5 minutes after the target statement
Prerequisites
Before you begin, ensure that you have:
A database instance running ApsaraDB RDS for MySQL or PolarDB for MySQL
The instance connected to DAS with status Accessed
A database version and region that support DAS Enterprise Edition V3 or Compliance Edition — see Editions and supported features
DAS Enterprise Edition V3 or Compliance Edition enabled for the instance — see DAS Enterprise Edition
Scenarios
You can analyze the commit or rollback status of a target SQL statement using audit logs.
Limitations
| Limitation | Details |
|---|---|
| Supported SQL types | INSERT, UPDATE, and DELETE only. |
| Analysis scope | Hot storage data only. To change the hot storage duration, click Service Settings in the upper-right corner of the SQL Explorer and Audit page. |
| Thread scope | The target statement's thread only. Concurrent transactions on other threads are not included. |
| Time window | Fixed at 10 minutes: 5 minutes before and 5 minutes after the target statement. Statements outside this window are not included. |
Hot storage incurs fees. For more information, see Billing details.
Run a quick transaction analysis
Log on to the DAS console.
In the left navigation pane, click Intelligent O&M Center > Instance Monitoring.
Find the target instance, and click the instance ID to open the instance details page.
In the left navigation pane, click Request Analysis > SQL Explorer and Audit, then click the Audit tab.
Search for the audit logs. In the log list, find the SQL statement to analyze, then click Quick Transaction Analysis in the Actions column.
View results
Results appear on the current page when the analysis is complete. To review historical analysis tasks, go to SQL Explorer > Transaction Analysis and find the Quick Transaction Analysis section.