Viewing Slow Query Logs of a DB Instance
Scenarios
This function displays a chart of SQL statements that are taking too long to execute and allows you to sort slow SQL statements by multiple dimensions, such as by user, host, or SQL template. It helps you quickly identify bottlenecks and improve instance performance.
Procedure
- Click
in the upper left corner and select a region.
- Click
in the upper left corner of the page and choose Databases > Relational Database Service.
- On the Instances page, click the target instance name.
- In the navigation pane, choose SQL Analysis and Tunning under DBA Assistant.
- Click the Slow Query Logs tab.
This function is only available with Advanced DBA Assistant.
- Click Upgrade DBA Assistant. In the displayed dialog box, you can learn about the enhanced features and billing rules.
- After the upgrade is complete, view slow queries over time of your instance.
- You can view slow queries over time and you can see the slow log archive history for the last 1 hour, last 3 hours, last 12 hours, or a custom time period (spanning no more than one day).
- To export slow query log details or statistics, click the Details or Statistics tab above the log list and click Export on the tab page.
Follow-up Operations
To view historical export records, do as follows:
- Above the log list, click the Details or Statistics tab.
- Click View All Export Records. The displayed dialog box shows all historical export records.
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