Database Autonomy Service:Features

Category

Feature

Description

Reference

Monitoring and alerting

24/7 anomaly detection

This feature detects exceptions 24/7 based on machine learning and fine-grained monitoring data.

Performance trend

This feature provides various performance metrics and custom charts, displays anomalous activities, and offers root cause analysis and suggestions. You can select a time range and manually perform diagnostics on database instances in the specified time range.

Monitoring dashboard

This feature allows you to select the database instances and metrics that you want to monitor. This way, you can use custom monitoring dashboards.

Real-time performance monitoring

This feature supports monitoring on the performance of a database instance at a latency of seconds.

Real-time monitoring dashboard

This feature supports monitoring on the performance of all database instances that are connected to DAS at a latency of seconds.

Performance insight

This feature can aggregate the statistics on SQL statements based on the Performance Schema feature provided by MySQL to help you identify performance issues at the earliest opportunity and provide solutions.

Alerting

This feature allows you to set custom alert items and alert thresholds. This way, you can use the alerting feature in multiple ways.

Inspection and scoring

Inspection and scoring

This feature helps you inspect and score all database instances as scheduled every day.

Diagnostics

Diagnostics

This feature helps you diagnose the performance of database instances and visualizes the diagnosis. This way, you can view the performance of database instances and quickly troubleshoot the cause of instance issues.

Diagnostic report

This feature allows you to initiate a diagnostic task for a database instance to check its status within a specific time range. This helps you evaluate the health status of your database instance from multiple dimensions, such as slow SQL queries, tablespaces, and performance trends, and troubleshoot the issues with ease.

SQL autonomy

Session management

This feature allows you to view the session information about a database instance in real time and perform O&M operations on sessions. For example, you can terminate a session and perform 10-second SQL analysis, SQL throttling, and SQL optimization on the database instance.

Query governance

This feature uses the offline data analysis technology to analyze all slow SQL queries that were executed on your database instances, add tags to SQL statements, and provide suggestions on optimizing SQL statements. This helps you categorize slow SQL queries and optimize slow SQL queries by governance priority.

Slow query log analysis

This feature aggregates statistics on and analyzes slow SQL statements that are executed on database instances and provides suggestions on optimizing slow SQL statements.

Deadlock analysis

This feature allows you to view and analyze the last deadlock in a database instance.

Automatic SQL throttling

This feature can automatically extract SQL statement characteristics and throttle problematic SQL statements by keyword.

Automatic SQL optimization

This feature can automatically diagnose slow SQL queries, generate index optimization suggestions, and create indexes without table locks.

Intelligent stress testing

This feature helps you check whether you need to scale out or up your database instance and test the scaling effect in real business scenarios to reduce the risk that may occur after your database instance is scaled out or up. In addition, if you cannot troubleshoot the error when your database instance fails, you can use the cloned database to replicate the error and better troubleshoot the cause of the failure.

Search and analysis

This feature allows you to query and export the logs of SQL statements.

SQL Explorer

This feature performs clustering analysis on SQL statements for in-depth troubleshooting.

Security audit

This feature provides more than 900 built-in rules for high-risk operations, including abnormal operations, data leaks, SQL injections, and attacks by exploiting vulnerabilities. This helps you automatically identify risks, such as high-risk operations, SQL injections, and new access sources.

Storage and performance autonomy

Storage analysis

This feature helps you view the storage usage of databases and tables in a visualized manner and identify exceptions at the earliest opportunity.

Capacity assessment

This feature allows you to view the capacity assessment suggestions, performance capacity, storage usage, and the estimated service time of available storage. This feature uses machine learning and capacity algorithms to predict future storage usage.

Automatic tablespace fragment recycling

This feature automatically recycles the tablespace fragments of a table in a MySQL database if a metric such as the tablespace size or fragmentation percentage of the table reaches the specified threshold. To minimize the impact on business, fragment recycling is performed in the maintenance window of a database instance after the workloads on the database instance are examined.

Auto scaling

Based on your preset scaling policy, the performance of the database instance after scaling, and the suggestions on storage space, this feature scales up or down your database instance if the performance of the database instance reaches the threshold.