OceanBase Cloud Platform (OCP) allows you to view the performance monitoring data of a cluster in different dimensions by using the following methods:
Method 1:
Log in to the OCP console. In the left-side navigation pane, click Performance Monitoring. The OceanBase Cluster tab automatically appears.
Method 2:
Log in to the OCP console and go to the Cluster Overview page. In the left-side navigation pane, click Performance Monitoring.
Prerequisites
You have the read-only privilege on the target cluster.
Procedure
The procedure of Method 1 is described as follows:
Log in to the OCP console.
In the left-side navigation pane, click Performance Monitoring.
The OceanBase Cluster tab automatically appears.
In the Data Filtering section, configure the parameters for filtering monitoring data.
The following table describes the filter 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. 
On the Database Performance tab, view the database performance monitoring data of the cluster.
- OCP allows you to view database performance monitoring data in four dimensions: cluster, tenant, OBServer node, and unit. By default, the system displays the monitoring data in the cluster 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.
Note
In the Query response time monitoring chart, the
99-alland95-allmetrics apply only to OceanBase Database V4.2.1.7 and versions later than V4.2.1.7 and earlier than V4.2.2.0.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.
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.
View detailed data of a specific point in time or a period of time: You can hover the pointer over a point in time on the trend chart to view the detailed data. You can also drag the pointer to select a period of time on the trend chart and have a zoomed-in view of data in this period of time. To resume the normal view, double-click the trend chart.
Zoom in on the trend chart: To use this feature, click the zoom-in icon in the upper-right corner. The features indicated by ① and ② in the preceding figure are also applicable to a zoomed-in chart.
Drill down to view monitoring data in different dimensions: If you find an abnormal metric such as a long query response time on the Cluster 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. The following drill-down dimensions are supported: cluster > 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 of the drill-down page, 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 click the link indicated by ① or ② to drill down to other dimensions for further analysis.
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, hover the pointer over the Go to Tenant Performance Monitoring link in the upper-right corner of the trend chart, and click the tenant name.
To go to the Monitoring page of a host, hover the pointer over the Go to Host Performance Monitoring link in the upper-right corner of the trend chart, and click the IP address of the host.
You can also click the button indicated by ③ or ④ in the upper-right corner of the trend chart to select the tenants or hosts whose data needs to be displayed on the trend chart.
(Optional) Configure the monitoring data collection interval.
By default, OCP collects monitoring data per second. This collection interval has high requirements for the OCP server performance and MonitorDB storage performance. If you do not require a high collection frequency, you can change the value of the
ocp.metric.collect.interval.secondparameter in theconfig_propertiesfile to increase the monitoring data collection interval, thus reducing required resources and increasing the manageable scale.Note
The system supports only the following values for this parameter: 1, 5, 10, and 15. If the value you entered is not one of them, the system adjusts the value based on the following rules:
- If the entered value is smaller than 1, it is adjusted to 1.
- If the entered value is in the range of [1, 5), it is adjusted to 1.
- If the entered value is in the range of [5, 10), it is adjusted to 5.
- If the entered value is in the range of [10, 15), it is adjusted to 10.
- If the entered value is greater than 15, it is adjusted to 15.
After you change the value, the configuration immediately takes effect. OCP collects monitoring data at this new interval. By default, the monitoring data display interval is three times the monitoring data collection interval, except for the case when the collection interval is 1 second. For example, if the monitoring data is collected every 5 seconds, the queried monitoring data is displayed by an interval of 15 seconds.