View performance and SQL monitoring data

OceanBase Cloud Platform (OCP) allows you to view the performance and SQL monitoring data of a tenant by using the following methods:

• Method 1: Log in to the OCP console and go to the tenant overview page. In the left-side navigation pane, click Performance Monitoring .

• Method 2: Log in to the OCP console. In the left-side navigation pane, click Performance Monitoring to go to the OceanBase Database Tenant tab.

Prerequisites

• To view the performance and SQL monitoring data of a tenant by using Method 1, make sure that you have the following permissions:

  • Cluster read-only or Resource Permissions : Cluster Read-only or Tenant Read-only permission
  • Menu Permissions : Permission on the Performance Monitoring menu of Tenants

• To view the performance and SQL monitoring data of a tenant by using Method 2, make sure that you have the following permissions:

  • Resource Permissions : Cluster Read-only, Tenant Read-only, or Host Read-only permission
  • Menu Permissions : Permission on the All menu of Performance Monitoring

Procedure

The procedure of Method 2 is described as follows:

1. Log in to the OCP console.

2. In the left-side navigation pane, click Performance Monitoring .

3. Click the OceanBase Database Tenant tab.

4. In the Data Filtering section, configure the parameters for filtering monitoring data.

   The following table describes the filter condition parameters.

   Parameter	Description
   Cluster	This parameter is not displayed in auto-refresh mode. Select a cluster to view its monitoring information.
   Zone	By default, the monitoring information of all zones is displayed.
   OBServer	By default, the monitoring information of all OBServer nodes is displayed.
   Select Time	This parameter is not displayed in auto-refresh mode. Select the time range of the data that you want to query.
   Auto Refresh	By default, the auto-refresh mode is disabled. After it is enabled, performance monitoring data is refreshed every 5 seconds.

   

5. On the Performance & SQL tab, view the performance and SQL monitoring data of the tenant.

   • OCP allows you to view monitoring data in two dimensions: tenant and unit. By default, the system displays the monitoring data in the tenant dimension. The metrics vary in different dimensions.

   • By default, the system displays all metrics in the current dimension. If you want to ignore a metric, click Select Metric on the right of the area and deselect the metric in the panel that appears.

   • For more information about the monitoring metrics, see Overview of metrics. If the statistical range covers multiple OBServer nodes, the aggregate metric values of the OBServer nodes are displayed.

     Note

     • The metrics related to the SQL execution time apply to OceanBase Database V3.2.4.1 and later, excluding V4.0.0.0.
     • The metrics related to the SQL execution phase apply to OceanBase Database V4.2.0.0 and versions later than V4.2.0.0 but earlier than V4.3.0.0. The in_committing, in_storage_read, in_storage_write, and in_remote_das_execution metrics apply to only OceanBase Database V4.2.1.0 and versions later than V4.2.1.0 but earlier than V4.3.0.0. The in_plsql_compilation and in_plsql_execution metrics apply to only OceanBase Database V4.2.2.0 and versions later than V4.2.2.0 but earlier than V4.3.0.0.
     • The metrics related to the foreground and background workloads apply to OceanBase Database V4.2.0.0 and versions later than V4.2.0.0 but earlier than V4.3.0.0.
     • The PX worker thread usage metric applies to OceanBase Database V4.0.0.0 and later.
     • In the Response time monitoring chart, the 95-all and 99-all metrics have the following limitations:
       • The metrics apply to only OceanBase Database of a version in the following ranges: [V4.2.1.7, V4.2.2.0), [V4.2.5.0, V4.3.0.0), or [V4.3.3.0, +∞).
       • You need to configure the following parameters on the Parameter Management page of the tenant in advance: Set the query_response_time_stats parameter to true to enable statistics collection, the query_response_time_range_base parameter to specify the statistical interval, such as 2, and the query_response_time_flush parameter to true to refresh the corresponding view and make the statistical interval effective.

   The following features enable you to better view and analyze the performance monitoring data on a trend chart. You can learn about the features with the help of the figure and description below.

   

   • Filter data:

     1. View the trend details of a metric over a specific period of time: To use this feature, drag the pointer over a period of time to select this period. The system will then zoom in to display the trend details. To resume to the normal view, double-click the trend chart, as indicated by ① in the preceding figure.

     2. Hide the data of a submetric: To use this feature, click the icon of this submetric. The submetric will then turn gray and its data will be hidden from the chart, as indicated by ② in the preceding figure.

     3. View the detailed data of a specific point in time: To use this feature, hover the pointer over a point in time on the trend chart, as indicated by ③ in the preceding figure.

   • Zoom in on a trend chart: To use this feature, click the zoom-in icon in the upper-right corner of the chart. The features indicated by ①, ②, and ③ in the preceding figure are also applicable to a zoomed-in chart.

   • View SQL request analysis: On the Response time trend chart, click SQL Request Analysis in the upper-right corner to view the request analysis details. For more information, see View SQL request analysis.

     Note

     SQL request analysis is available only on the Response time trend chart.

   • Drill down to view monitoring data in different dimensions: If you find an abnormal metric such as a long response time of a tenant on the Tenant Dimension tab, perform drill-down analysis to identify the faulty server. Click the Drill-down Analysis icon in the upper-right corner of the trend chart to view the drill-down analysis details. The Performance & SQL tab supports the following drill-down dimensions: tenant > OBServer node.

     The features indicated by ①, ②, and ③ in the preceding figure are also applicable to a trend chart on a drill-down page. You can also perform the following operations:

     

     • In the Data Filtering section indicated by ① in the figure, specify filter conditions. If you do not specify any filter conditions, the drill-down page automatically inherits filter conditions from the upper-level page.

     • If the metric has submetrics, you can view the submetrics or drill down to other dimensions, as indicated by ② in the figure.

     • The trend chart provides the Search for SQL Statement with Most Requests link, as indicated by ③ in the figure, for you to view the top SQL diagnostic details of the tenant.

     • The trend chart also provides an entry to the host performance monitoring feature. Hover the pointer over the Go to Host Performance Monitoring link, as indicated by ④ in the figure, and click the target host to go to its Performance Monitoring page and view the monitoring details.

     • You can also click the icon indicated by ⑤ in the upper-right corner of the trend chart and select the hosts whose performance monitoring data needs to be displayed on the trend chart.