View performance and SQL

This topic describes how to view tenant performance and SQL monitoring data in OCP. You can access this information through the following two methods:

• Method 1: Log in to OCP, go to the Tenant Overview page, and click Performance in the left navigation pane.

• Method 2: Log in to OCP, click Performance in the left navigation pane to go to the OceanBase Tenant tab.

Prerequisites

• When viewing tenant performance and SQL performance monitoring data through Entry 1, ensure the current OCP user has the following permissions:

  • Cluster Read-Only or Tenant Read-Only resource permission.
  • Tenant Performance Monitoring menu permission.

• When viewing tenant performance and SQL performance monitoring data through Entry 2, ensure the current OCP user has the following permissions:

  • Cluster Read-Only, Tenant Read-Only, or Host Read-Only resource permission.
  • Performance Monitoring All menu permission.

• To view the Response Time monitoring chart, you must configure the following parameters in advance under Tenant > Parameter Management:

  • query_response_time_stats=true (Enable statistics)

  • query_response_time_range_base=2 (Set the statistics interval)

  • query_response_time_flush=true (Refresh to apply the modified statistics interval)

Version limitations

• The SQL Execution Time monitoring metric applies to OceanBase versions [V3.2.4.1, V4.0.0.0), [V4.1.0.0, +∞).

• The SQL Execution Phase monitoring metric applies to OceanBase versions [V4.2.0.0, V4.3.0.0). Specifically:

  • Sub-metrics in_committing, in_storage_read, in_storage_write, and in_remote_das_execution apply to OceanBase versions [V4.2.1.0, V4.3.0.0).
  • Sub-metrics in_plsql_compilation and in_plsql_execution apply to OceanBase versions [V4.2.2.0, V4.3.0.0).

• The Clog Synchronization Latency monitoring metric applies to OceanBase versions [V2.2.76, V4.0.0.0).

• The Frontend Workload and Backend Workload monitoring metrics apply to OceanBase versions [V4.2.0.0, V4.3.0.0).

• The DB Time monitoring metric applies to OceanBase versions [V4.2.2.0, V4.3.0.0).

• The Parallel Execution Worker Thread Utilization monitoring metric applies to OceanBase version [V4.0.0.0, +∞).

• For the Response Time monitoring metric:

  • Sub-metrics 99-all and 95-all apply to OceanBase versions [V4.2.1.7, V4.2.2.0), [V4.2.5.0, V4.3.0.0), [V4.3.3.0, +∞).
  • Sub-metrics commit and rollback apply to OceanBase versions [V4.2.5.3, V4.3.0.0), [V4.3.5.2, +∞).

• For the QPS monitoring metric, sub-metrics commit and rollback apply to OceanBase versions [V4.2.5.3, V4.3.0.0), [V4.3.5.2, +∞).

• The RPC Request Success Rate, GTS Requests, RPC Network Latency, and RPC Delivery Failure monitoring metrics apply to OceanBase versions [V2.2.70, +∞).

Procedure

The following steps use Entry 2 as an example.

1. Log in to OCP.

2. In the left navigation bar, select Performance Monitoring.

3. Select the OceanBase Tenant tab.

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

   The filtering criteria are described in the following table:

   Criterion	Description
   Refresh	Refreshes monitoring data. Automatic refresh is supported and is disabled by default. When automatic refresh is enabled, you can configure the refresh frequency.
   Selection Time (also known as: Monitoring Window)	Not displayed in automatic refresh mode. Select a time range to retrieve data within that period.
   Tenant	Select a specific tenant to monitor.
   Zone	By default, all zones are monitored.
   OBServer	By default, all OBServer nodes are monitored.

5. The system enters the Performance and SQL tab by default, where you can view tenant performance and SQL monitoring data.

   • OCP supports viewing monitoring data from two dimensions: tenant and unit. Data is displayed by default in the tenant dimension. The monitoring metrics supported vary by dimension.
   • The system displays all monitoring items for the current dimension by default. If you do not need to focus on a particular monitoring item, you can uncheck it in the Selected Chart panel on the right side of the area.
   • All monitoring items support displaying the maximum value (max), average value (avg), and current value (current) for each sub-metric.
   • For the specific meaning and value source of all monitoring items, refer to Overview of Monitoring Metrics. If the statistical range involves multiple OBServer nodes, aggregated values are displayed.

   The following features help you better view and analyze detailed performance monitoring data in trend charts. You can understand them in combination with the images and the following text.

   • View and hide data for other sub-metrics: Hover the cursor over the metric area and scroll the mouse wheel up or down to view data for all sub-metrics displayed in the trend chart. Click the identifier of another sub-metric to gray it out, and that metric's information will not be displayed in the trend chart.

   • Hover the cursor over a point in time in the trend chart to view detailed data at that moment. Drag the cursor to select an area, and the system will zoom in to display the trend information for that area. You can view the detailed trend of that metric during this time period. Double-click the trend chart to restore it.

   • Zoom in on a trend chart: Click the zoom icon in the upper-right corner of the trend chart. The functions of ① and ② in the preceding figure also apply to the zoomed-in trend chart.

   • Edit a monitoring metric: Click the edit icon in the upper-right corner of the trend chart to choose which sub-metrics to display.

   • Drill down to view monitoring data from different dimensions: On the Tenants tab, if you find abnormal monitoring data for a tenant, such as excessively high tenant response time, you can perform drill-down analysis to locate the server causing the abnormal response time. Click the Drill-down Analysis icon in the upper-right corner of the trend chart to view the drill-down analysis details. Performance and SQL supports drilling down by the following dimensions: Tenant > OBServer.

     The functions of ① and ② in the preceding figure also apply to the trend chart on the drill-down page. Additionally, you can:

     • Reset the filtering criteria on the drill-down page. If you have not set criteria, the settings from the parent level will be automatically inherited.

     • If the metric has sub-metrics, you can select them to view.

     • The trend chart provides an SQL search function. Click the corresponding link to view the TopSQL diagnostic details for the tenant.

     • Provides the Go to Host Performance Monitoring feature. Hover the cursor over the Go to Host Performance Monitoring link and select the host you want to view to jump to the Performance Monitoring page of the relevant host for detailed monitoring information.

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

     Note

     Only Response Time supports viewing SQL request analysis.

   • View session analysis: In the Sessions trend chart, click the Session Analysis icon in the upper-right corner of the chart to view the session analysis details. For more information, see Manage tenant sessions.

     Note

     Only Sessions supports viewing session analysis.