Slow SQL queries significantly decrease the database stability. When issues such as high workloads and performance jitters occur on a database, database administrators or developers first check whether slow query logs are generated.

Common methods to view slow query logs

  • Directly view the logs.

    Disadvantages:

    • Slow query log records are not easy to read because they are not parameterized, aggregated, or sampled.
    • Issues cannot be identified or fixed in a short period of time.
  • View the logs by using self-managed slow query log platforms.

    Disadvantages:

    • Self-managed log collection, computing, and storage platforms incur high costs.
    • Platform development and O&M personnel are required.

Slow query log analysis feature of DAS

DAS provides the slow query log analysis feature. You can view the trends, statistics, and details of slow query logs in the DAS console.

  • Benefits
    • Easy to use
    • Low costs: You do not need to build your own log collection, computing, or storage platforms. This helps you reduce costs.
    • Closed-loop management: Slow query logs can be managed during their lifecycle, including discovery, analysis, diagnosis, optimization, and tracking.
    • Low requirements for technical skills: Professional data administrators are not required.
  • Architecture