Performance monitoring

You can view the performance monitoring data of a cluster in different dimensions.

Prerequisites

The logged-on user in the OceanBase Cloud Platform (OCP) console has the read-only permission on the target cluster.

Procedure

1. Log on to the OCP console.

   The Clusters page automatically appears.

2. In the Clusters list, find the target cluster and click its name.

3. In the left-side navigation pane on the page that appears, click Performance Monitoring .

4. In the Data Filtering section, you can filter the performance data to display.

   The following table describes the filter conditions.

   Filter condition	Description
   Select Time	It is not displayed in real-time mode. Select a time range for the data that you want to query.
   Stat Period	It is not displayed in real-time mode. Select the statistical period for each data point. Valid values: Per Minute and Per Second , which respectively means one data point per minute and one data point per second. OCP also calculates one more statistical period based on the selected time range by increasing the number of data points to approximately 1,440. If the selected time range is long, the statistical period may be longer than one minute.
   Statistical Range	Select a zone or an OBServer in a zone as the statistical range. By default, the monitoring data of all zones is collected.

   

   • Turn off Real-time : After you specify the filter conditions, the system displays the performance monitoring data based on the specified Select Time and Stat Period .

   • Turn on Real-time : After you specify a statistical range, the system displays the real-time performance monitoring data in the range.

5. View the performance monitoring data on the Database Performance and Host Performance tabs.

   For more information about monitoring metrics, see Metrics.

   • Click the Database Performance tab.

     To display other metrics, click Select Metric on the right side and select the metrics that you want to display. The system can display up to 10 metrics.

   • Click the Host Performance tab.

     If multiple OBServers are specified as the statistical range, their average value of each metric is displayed.

   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 below.

   Note

   You can only use the drill-down feature on the Performance Monitoring page of Clusters and Tenants .

   1. View the trend details of a metric over a specific period. To use this feature, drag the pointer over the period to select this period. The system will then zoom in to display the trend details. After you view the trend details, double-click the trend chart to return to normal.

   2. Hide the data of a submetric. To use this feature, click the icon of the submetric. The submetric will then turn gray and its data will be hidden from the chart.

   3. View data at a specific time point. To use this feature, move the pointer over this time point on the trend chart.

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

   5. View monitoring data in different dimensions through drill-down. When you find an abnormal metric, such as high response time, of a tenant, you can locate the faulty server through drill-down analysis. To use this feature, click the Drill-down Analysis icon in the upper-right corner of the trend chart.

      • The Database Performance tab supports the following drill-down dimensions: cluster > tenant > OBServer

      • The Host Performance tab supports the following drill-down dimensions: cluster > host

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

      

      1. In the Data Filtering section of the drill-down page, specify filter conditions. If you do not specify any of them, the drill-down page automatically inherits filter conditions from the upper-level page.

      2. If the metric has submetrics, you can view the submetrics or click ① or ② to drill down to other dimensions for further analysis.

      3. If the metric is involved in the performance of a tenant or host, you can directly go to the monitoring page of the tenant or server from the trend chart.

         • To go to the Performance Monitoring page of the tenant, move the pointer over the Go to Tenant Performance Monitoring link in the upper-right corner of the trend chart, and then select and click the tenant.

         • To go to the Monitoring page of the host, move the pointer over the link for redirection in the upper-right corner of the trend chart, and then select and click the host.

      4. You can also click the button in section ③ or ④ in the upper-right corner of the trend chart to select the tenant or host whose data needs to be displayed on the trend chart.