Slow Query Logs

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 GeminiDB console.
2. In the service list, choose Databases > GeminiDB Redis API.
3. In the navigation pane, choose Log Reporting.
4. Select an instance and click next to Report Slow Log 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 1 Reporting slow query logs to LTS
   

Viewing Log Details

1. Log in to the GeminiDB console.
2. In the service list, choose Databases > GeminiDB Redis API.
3. On the Instances page, click the target instance.
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 2 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 3 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.

6. On the Log Details page, click in the upper right corner of the log list to export log details.
   • You can view the CSV file exported to your local PC.
   • Up to 2,000 logs can be exported at a time.
     Figure 4 Exporting slow query logs