Slow Query Logs

Viewing Log Details

1. Log in to the management console.
2. In the service list, choose Databases > GeminiDB Redis API.
3. On the Instances page, locate the instance whose slow query logs you want to view and click its name.
4. In the navigation pane on the left, choose Slow Query Logs.
5. On the Slow Query Logs page, set search criteria and click Search to view log information.
   Figure 1 Viewing slow query logs
   
   

   For some instances of earlier versions, the kernel minor version needs to be upgraded to support metrics Database Where a Big Key Is Located, Request Size, Number of Request Parameters, Returned PACKET Size, and Number of Returned Values.

   • Select All nodes and view slow query logs of all nodes. Alternatively, select a specific node to view its slow query logs.
     Figure 2 Querying nodes
     

   • Choose to view slow query logs of all types of SQL statements or a specific SQL statement.
     • SET
     • GET
     • DEL
     • INCR
     • INCRBY
     • INCRBYFLOAT
     • DECR
     • DECRBY
     • GETSET
     • APPEND
     • MGET

     ······

     

     You can view slow query logs of all types of Redis SQL statements.

   • View slow query logs of a specific node in different time ranges.

Reporting Slow Query Logs to LTS

To use this function, you need to contact customer service to apply for required permissions.

1. Log in to the management console.
2. In the service list, choose Databases > GeminiDB Redis API.
3. In the navigation pane, choose Log Reporting.
4. Click next to the Report Logs to LTS field and configure slow log reporting to LTS.
5. Select an LTS log group and log stream and click OK.
   

   You will be billed for enabling this function. For details, see LTS pricing details.

   Figure 3 Enabling slow log reporting to LTS