Help Center/ Distributed Cache Service/ User Guide/ Diagnosing and Analyzing an Instance/ Viewing Slow Queries of a DCS Redis Instance
Updated on 2024-10-17 GMT+08:00
View PDF
Share

Viewing Slow Queries of a DCS Redis Instance

Redis logs queries that exceed a specified execution time. You can view the slow logs on the DCS console to identify performance issues.

For details about the commands, visit the Redis official website.

Configure slow queries with the following parameters:

  • slowlog-log-slower-than: The maximum time allowed, in microseconds, for command execution. If this threshold is exceeded, Redis will log the command. The default value is 10,000. That is, if command execution exceeds 10 ms, the command will be logged.
  • slowlog-max-len: The number of slow queries in a record. The default value is 128, which means a maximum of 128 latest slow queries can be displayed.

The following parameters are available only in the CN East-Shanghai2 and CN South-Guangzhou regions.

  • proxy-slowlog-log-slower-than: The maximum time allowed, in microseconds, for command execution. If this threshold is exceeded, Redis will log the command. The default value is 256,000. That is, if command execution exceeds 256 ms, the command will be logged.
  • proxy-slowlog-max-len: The number of slow queries in a record. The default value is 128, which means a maximum of 128 latest slow queries can be displayed.

For details about the configuration parameters, see Modifying Configuration Parameters of a DCS Instance.

Notes and Constraints

  • You can view the slow queries of a Proxy Cluster DCS Redis 3.0 instance only if the instance is created after October 14, 2019.
  • Currently, you can view slow queries in the last seven days.
  • After restarting an instance, slow queries before the restart cannot be viewed.

Procedure

  1. Log in to the DCS console.
  2. Click in the upper left corner of the management console and select the region where your instance is located.
  3. In the navigation pane, choose Cache Manager.
  4. Click the name of a DCS instance.
  5. Choose Analysis and Diagnosis > Slow Queries.
  6. Select a start date and an end date and click the refresh icon to view slow queries within the specified period. For details about the commands, visit the Redis official website.

    To filter slow queries, click the filtering bar, select a property or enter a keyword.

    Currently, slow queries of only Proxy Cluster and read/write splitting instances in the CN East-Shanghai1, CN East-Shanghai2, and CN South-Guangzhou regions contain Proxy and Redis Server categories for proxy and Redis instance node records.

    • For Proxy Cluster and read/write splitting instances created before August 2024, and the proxies are not upgraded, contact technical support to upgrade proxies. Otherwise, the slow queries under Proxy is always blank.
    • The real client IP address is in the Client IP Address column of the slow query list of an instance with client IP pass-through enabled. For Proxy Cluster and read/write splitting instances, the real client IP address is in the Proxy column.
    Figure 1 Slow queries of an instance

  7. To download slow queries, choose Export > Export all data to an XLSX file or Export selected data to an XLSX file.