AWS – Database Insights provides on-demand analysis for RDS MySQL and RDS MariaDB

Amazon CloudWatch Database Insights expands the availability of its on-demand analysis experience to the RDS for MySQL and RDS for MariaDB database engines. This feature leverages machine learning models to help identify performance bottlenecks during the selected time period, and gives advice on what to do next.

This launch allows you to analyze database performance monitoring data for a time period of your choice. You can learn how the selected time period differs from normal, what went wrong, and get advice on corrective actions. Through simple-to-understand graphs and explanations, you can identify the chief contributors to performance issues. You will also get guidance on the next steps to act on these issues. This can reduce the mean-time-to-diagnosis for database performance issues from hours to minutes.

You can get started with this feature by enabling the Advanced mode of Database Insights on your RDS for MySQL or RDS for MariaDB databases using the RDS service console, AWS APIs, the AWS SDK, or AWS CloudFormation. Please refer to RDS documentation and Aurora documentation for information regarding the availability of this feature across different RDS and Aurora engines, respectively. CloudWatch Database Insights delivers database health monitoring aggregated at the fleet level, as well as instance-level dashboards for detailed database and SQL query analysis.

CloudWatch Database Insights is available in all commercial AWS Regions and offers vCPU-based pricing – see the pricing page for details. For further information, visit the Database Insights User Guide.

Read More for the details.