Slow Query Logs
GeminiDB Redis allows you to view slow query logs of databases. The unit of the execution time is ms. You can identify the SQL statements that take a long time to execute and tune them based on slow query logs.
Viewing Log Details
- Log in to the management console.
- In the service list, choose Databases > GeminiDB Redis API.
- On the Instances page, locate the instance whose slow query logs you want to view and click its name.
- In the navigation pane on the left, choose Slow Query Logs.
- 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.
- Select All nodes and view slow query logs of all nodes. Alternatively, select a specific node to view its slow query logs.
Reporting Slow Query Logs to LTS
To use this function, you need to contact customer service to apply for required permissions.
- Log in to the management console.
- In the service list, choose Databases > GeminiDB Redis API.
- In the navigation pane, choose .
- Click
next to the Report Logs to LTS field and configure slow log reporting to LTS.
- Select an LTS log group and log stream and click OK.
Figure 3 Enabling slow log reporting to LTS
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot