Database Autonomy Service (DAS)
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. |
Anomaly detection |
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. |
Performance trends | |
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. |
Monitoring dashboards | |
Real-time performance monitoring |
This feature supports monitoring on the performance of a database instance at a latency of seconds. |
Real-time performance monitoring | |
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. |
Real-time monitoring dashboard | |
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. |
Performance insight | |
Alerting |
This feature allows you to set custom alert items and alert thresholds. This way, you can use the alerting feature in multiple ways. |
Configure alerting | |
Inspection and scoring |
Inspection and scoring |
This feature helps you inspect and score all database instances as scheduled every day. |
Inspection And Scoring |
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. |
Diagnostics |
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. |
Diagnostic reports | |
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. |
Session management |
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. |
Query governance | |
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. |
Slow SQL Statements | |
Deadlock analysis |
This feature allows you to view and analyze the last deadlock in a database instance. |
Deadlock analysis | |
Automatic SQL throttling |
This feature can automatically extract SQL statement characteristics and throttle problematic SQL statements by keyword. |
Automatic SQL throttling | |
Automatic SQL optimization |
This feature can automatically diagnose slow SQL queries, generate index optimization suggestions, and create indexes without table locks. |
Automatic SQL optimization | |
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. |
Intelligent stress testing | |
Search and analysis |
This feature allows you to query and export the logs of SQL statements. |
Search | |
SQL Explorer |
This feature performs clustering analysis on SQL statements for in-depth troubleshooting. |
SQL Explorer | |
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. |
Security audit | |
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. |
Storage analysis |
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. |
Capacity assessment | |
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. |
Automatic tablespace fragment recycling | |
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. |
Auto Scaling |