Help Center/ TaurusDB/ User Guide/ DBA Assistant/ What Is DBA Assistant?
Updated on 2026-05-09 GMT+08:00
View PDF
Share

What Is DBA Assistant?

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, resource usage, health status, performance metrics, and storage usage, it helps you quickly locate faults and keep track of instance statuses.

Prerequisites

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

Introduction Video

Functions

Table 1 lists the functions supported by DBA Assistant.

Table 1 Function description

Function

Description

Reference

Sessions

The Sessions page displays slow sessions, active sessions, and total sessions. 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

The Performance page 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.

Performance Monitoring

Storage Analysis

Storage occupied by data and logs and changes of storage usage are important for database performance. The Storage Analysis page displays storage overview and disk space distribution of your instance. In addition, DBA Assistant can estimate the available days of your storage based on historical data and intelligent algorithms, so that you can scale up storage in a timely manner. Autoscaling, Tablespaces, Top 50 Databases, and Top 50 Tables are also available on this page.

Managing Storage

Anomaly Snapshots

After anomaly diagnosis is enabled, the system checks your instance health status and diagnoses faults. Once an anomaly is detected, the system collects its snapshots, helping you monitor instance performance in real time.

Viewing Anomaly Snapshots

Locks & Transactions

You can check whether your instance has metadata locks and InnoDB locks. You can also check the recent deadlock analysis and full deadlock analysis.

Managing Locks and Transactions

Daily Reports

The Daily Reports page summarizes the instance status of the previous day, covering performance and storage analysis, SQL analysis, and database/table analysis. You can download and subscribe to analysis reports. You are advised to perform instance diagnosis every day to keep workloads running smoothly.

Managing Daily Reports

Slow Query Logs

Displays slow queries within a specified time period. You can view top slow query logs by user or IP address, sort statistics, and identify sources of slow SQL statements.

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.

Configuring SQL Throttling

Enabling Auto Kill Sessions

You can kill all sessions, kill specific sessions by criteria, and view the session termination history.

Using Auto Kill Sessions

Auto Throttling

This function checks for database exceptions, such as high vCPU usage and excessive active sessions, and throttles traffic based on specified priorities.

You can use this function to throttle traffic by database or user. Throttling traffic of non-core databases or non-core workloads can ensure that core workloads remain stable.

Configuring Auto Throttling
Parent Topic: DBA Assistant