With the request analysis feature, you can diagnose the SQL health status of databases under a tenant within a specified time range.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance, click the instance name, and go to the Overview page of the instance.
In the left-side navigation pane, click Diagnostics. On the Diagnostics page, select the Real-Time Diagnostics tab.
Click the Request Analysis tab at the bottom of the page.
(Optional) Configure the filter conditions.
Time: You can view data for the following time periods: Past 5 Minutes, Past 30 Minutes, Past 1 Hour, and Past 6 Hour(s). You can also customize the time period, with a maximum of 15 days. However, note the following limitations:
- Maximum range: The selected time period must not exceed 24 hours.
- Minimum range:
- For data within 3 days: The selected time period must be at least 1 minute.
- For data from 3 to 7 days: The selected time period must be at least 5 minutes.
- For data beyond 7 days: The selected time period must be at least 20 minutes.
Database: Select any database in the current cluster.
SQL Type: Select the type of SQL to query. You can choose multiple types.
Click Query.
As shown in the preceding figure:
Execution Time Percentage: Shows the distribution of execution times for all SQL statements in the selected time period. The system divides the execution times into the following five intervals:
(0, 10]ms, which indicates the percentage of SQL statements with execution times greater than 0 ms and less than or equal to 10 ms. This interval is displayed in blue.
(10, 100]ms, which indicates the percentage of SQL statements with execution times greater than 10 ms and less than or equal to 100 ms. This interval is displayed in green.
(100, 500]ms, which indicates the percentage of SQL statements with execution times greater than 100 ms and less than or equal to 500 ms. This interval is displayed in orange.
(0.5, 5]s, which indicates the percentage of SQL statements with execution times greater than 0.5 s and less than or equal to 5 s. This interval is displayed in gray.
-
5s, which indicates the percentage of SQL statements with execution times greater than 5 s. This interval is displayed in light blue.
Note
The healthier the SQL health of a database is, the closer its execution time percentage is to blue. The worse the SQL health is, the closer its execution time percentage is to gray and light blue.
Number of executions: Shows the number of executions of SQL statements in the selected time period.
Database Request Statistics: Shows the execution count, execution count percentage (%), average response time (ms), and execution trend of the database in the selected time period.
Table Request Statistics: Shows the execution count, execution count percentage (%), average response time (ms), and execution trend of tables in the selected time period.
