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 describe how to analyze slow query logs. ApsaraDB RDS for MySQL databases are used in the example.
Prerequisites
- MySQL
- PostgreSQL
- Redis
- MongoDB
- PolarDB
Note MySQL, PostgreSQL, Redis, and MongoDB databases can be Alibaba Cloud databases or
self-managed databases.
View slow query logs of a single database instance
View the global trend of slow query logs
If you have multiple database instances, you can view the global trend and analysis of slow query logs of top 10 instances on the Global Slow Log Trend page.
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.