Tuning Report
Scenarios
The diagnosis report displays the data in the database in a specified period, such as the real-time performance data, session statistics, slow SQL statements, and SQL tuning content.
Prerequisites
- You have obtained the process permission.
Procedures
- On the top menu bar, choose CloudDBA > Tuning Report. Figure 1 Tuning Report
- On the displayed page, click Start Diagnosis. In the displayed dialog box, set duration and frequency and click OK.
- Search for diagnosis reports by time range. Click View Report in the Operation column to view report details.
- On the details page, view metrics such as thread_conn, QPS, and com_del in real time. You can analyze the diagnosis based on performance data, session statistics, slow SQL statements, and SQL tuning content, and download the diagnosis report. Figure 2 Diagnosis details
Last Article: SQL Tuning
Next Article: InnoDB Lock Query
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.