All Products
Search
Document Center

Slow query log analysis overview

Last Updated: Jun 02, 2020

Background information

Slow query log issues greatly affect the stability of databases. When databases suffer issues such as high loads and performance jitter, the administrator or developer will first check whether slow query logs are being collected.

Common methods to view slow query logs

Direct view

Disadvantages:

  • Poor readability because slow query logs are not parameterized, aggregated, or sampled.
  • Existing issues cannot be quickly located or fixed.

Use user-created slow query log platforms

Disadvantages:

  • User-created log collection, computing, and storage platforms incur high costs.
  • Platform development and maintenance personnel are required.

Use the 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 on DAS.

Benefits

  • Ease of use
  • Low costs

    User-created log collection, computing, and storage platforms are not required and this saves costs.

  • A complete process

    DAS delivers a full lifecycle management process covering discovery, analysis, diagnosis, optimization, and tracking of slow query logs.

  • No experts involved

    Platform development and maintenance personnel are not required.