Updated on 2025-06-13 GMT+08:00

Managing Historical Transactions

Introduction

This function is used to analyze and discover large transactions and the transactions that have been there for a long time without being committed in the database.

Data on historical transactions comes from the output of the SHOW ENGINE INNODB STATUS command. It shows the snapshot of historical transactions and is collected every 5 minutes.

Constraints

  • The snapshot of historical transactions only lists the transactions that are currently being executed. It does not include those that started and committed during a collection interval.
  • To collect historical transactions, enable Collect Slow Query Logs or Collect All SQL Statements first.
  • A maximum of 10,000 records generated in the past 7 days can be displayed.

Procedure

  1. Click in the upper left corner and select a region.
  2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  3. On the Instances page, click the target instance name.
  4. In the navigation pane, choose DBA Assistant > Historical Diagnosis.
  5. Click the Historical Transactions tab.
  6. In the upper part of the page, click Log Settings, enable Collect Slow Query Logs or Collect All SQL Statements, and click OK.

    Figure 1 Log Settings

  7. Enable Collect Historical Transactions and view historical transactions.

    Figure 2 Collect Historical Transactions