Help Center/ Relational Database Service_RDS for MySQL/ User Guide/ Problem Diagnosis and SQL Analysis/ Function Overview
Updated on 2026-01-19 GMT+08:00
View PDF
Share

Function Overview

DBA Assistant provides visualized database O&M and intelligent diagnosis for developers and database administrators (DBAs), making database O&M easy and efficient. By analyzing alarms, resources, health data, performance metrics, and storage usage, it helps users quickly locate faults and keep track of instance status.

To use DBA Assistant on the RDS console, IAM users must have the RDS FullAccess, DAS FullAccess (or DAS Administrator), and CES FullAccess permissions. To grant these permissions, see Using IAM Roles or Policies to Grant Access to RDS.

Video

Scenarios

  • Setting a slow session threshold can help you quickly identify abnormal sessions and kill the sessions when an exception occurs in your instance, so that your instance can recover quickly and ensure database availability.
  • If your DB instance is unstable due to a large number of concurrent SQL requests from new services, you can set SQL throttling rules for SQL statements to limit concurrent SQL statements and ensure instance stability.
  • If your instance storage is full, you can learn about the storage usage and disk space distribution on the Storage Analysis page. You can enable storage autoscaling. When the available storage of your instance drops to the threshold, autoscaling is triggered. For details, see Configuring Storage Autoscaling.
  • You can configure auto throttling to limit active connections in high burst traffic or abnormal read/write scenarios to ensure the availability of core workloads.

Functions

Table 1 lists the functions supported by DBA Assistant.

Table 1 Function description

Function

Description

Reference

Sessions

It displays session statistics. You can quickly filter slow sessions or active sessions by user, host IP address, or database name. Kill Session and SQL Throttling can be used for urgent instance recovery to ensure database availability.

Managing Real-Time Sessions

Performance

It displays key metrics of your instance and provides metric comparison between different days. You can keep track of metric changes and detect exceptions in a timely manner. Monitoring by Seconds helps accurately locate faults.

Viewing Performance Metrics

Storage Analysis

Storage occupied by data and logs and historical changes of storage usage are important for database performance. DBA Assistant shows the storage summary and storage space usages of your instance. It estimates the available days of your storage based on historical data and intelligent algorithms, helping you scale up storage before it runs out. Autoscaling, Tablespaces, Top 50 Databases, and Top 50 Tables are also available on this page.

Managing Storage Capacity

Locks & Transactions

It analyzes metadata locks and InnoDB locks. You can manage blocked transactions using metadata lock views and InnoDB lock topologies to reduce lock conflicts.

Managing Locks & Transactions

Historical Transactions

It analyzes and identifies large transactions and the transactions that have been there for a long time without being committed in the database.

Managing Historical Transactions

Slow Query Logs

It displays slow queries within a specified time period. You can sort top slow queries by user or client IP address, view slow query statistics, and sort them by specific dimensions to identify the sources of slow SQL queries.

Viewing Slow Query Logs

SQL Explorer

After Collect All Query Logs is enabled, you can filter, search for, and analyze SQL statements in multiple dimensions and gain a comprehensive insight into all SQL statements. Top SQL helps you locate exceptions.

SQL Throttling

SQL Throttling restricts the execution of SQL statements based on specified rules when there are SQL statements that cannot be optimized timely or a resource (for example, vCPU) bottleneck occurs.

Creating a SQL Throttling Rule

Auto Throttling

This function automatically detects database exceptions such as high vCPU usage and excessive active sessions, and limits traffic based on specified priorities.

You can control traffic by database or user as required. Limiting traffic of non-core databases or from non-core users can ensure that core workloads remain stable.

Configuring Auto Throttling

Daily Reports

The Daily Reports page provides overall information about your instance status of the previous day, including slow SQL analysis, all SQL analysis, and performance & storage analysis. You can download and subscribe to analysis reports. A daily diagnosis is recommended.

Daily Reports

Anomaly Snapshots

This function intelligently detects instance anomalies and records information about session, lock, and transaction snapshots to facilitate subsequent fault locating.

Managing Anomaly Snapshots
Parent Topic: Problem Diagnosis and SQL Analysis