In an ApsaraDB for Redis instance, the keys that are frequently accessed are called hotkeys. Improper management of hotkeys may cause congestion and degrade service performance. You can use the audit log feature to query and analyze the historical hotkeys. This allows you to further optimize your instance.

Prerequisites

The audit log feature is enabled for the ApsaraDB for Redis instance. For more information about audit logs, see Enable the new audit log feature.

Background information

ApsaraDB for Redis uses efficient sorting and statistical algorithms based on the Least Frequently Used (LFU) cache to identify hotkeys in an instance.
Note If the number of queries per second (QPS) of a key is greater than 3,000, the key is considered to be a hotkey.

Procedure

  1. Log on to the ApsaraDB for Redis console and go to the Instances page. In the top navigation bar, select the region in which the instance is deployed. Then, find the instance and click the instance ID.
  2. In the left-side navigation pane, choose Logs > Audit Log.
  3. On the Audit Log page, click Please Select in the upper-right corner. In the Time panel, specify a time range that you want to query. In this example, 1 Week is selected, which indicates the last week.
    Select a time range
  4. Clear the default filter conditions in the Keyword field. Enter type:7 and press the Enter key. The type:7 filter condition is used to query hotkeys.
    Set the Keyword field
  5. In the Audit log detail, view the details of the historical hotkeys.
    Historical hotkeys
    Note The Client ip column displays 127.0.0.1, which is the IP address of the local host of the ApsaraDB for Redis instance.

    In the Command column, view the details of the hotkeys. The following table describes the fields in the hotkey details.

    Field Example Description
    dbid "dbid":0 The database in which the hotkey resides.
    type "type":"string" The type of data structure that the hotkey uses.
    lfu "lfu":241 The LFU value of the hotkey.
    qps "qps":"4500-5000" The QPS of the hotkey. The value is displayed as a range.
    Note If the QPS of a key reaches 6,000, the system stops calculating the accurate QPS of the key. In this case, >=6000 is displayed for such a hotkey.
    key "key":"key:000000000008" The hotkey.