Database Autonomy Service (DAS) provides the slow query log analysis feature. You can view the trends, execution, and optimization suggestions of slow query logs in the DAS console. This topic describes how to analyze slow query logs. ApsaraDB RDS for MySQL databases are used in the example.
Prerequisites
- RDS MySQL
- RDS PostgreSQL
- PolarDB MySQL
- PolarDB PostgreSQL
- PolarDB-O
- Redis
- MongoDB
View the slow query logs of a single instance
View the global trend of slow query logs
If you have multiple database instances, you can view the global trend and the analysis of slow query logs of the top 10 instances in the Global Slow Log Trend section.
Note The global trend feature for slow query logs is available only for self-managed MongoDB,
MySQL, and Redis databases, ApsaraDB RDS for MySQL databases, and ApsaraDB for Redis
databases.
- Log on to the DAS console.
- In the left-side navigation pane, choose Request Analysis > Slow Logs to view Global Slow Log Trend and Top Instance Statistics.