Performance monitoring

This topic describes the tenant performance monitoring feature of OceanBase Cloud Platform (OCP).

Prerequisites

The logged-on user in the OCP console has the read-only permission on the target tenant.

Procedure

1. Log on to the OCP console.

2. In the left-side navigation pane, click Tenants to go to the Tenant Overview page.

3. In the Tenants list, find the target tenant and click its name.

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

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

   The following table describes the filter conditions.

   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	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 The calculation is performed by increasing the number of data points to approximately 1440. 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 value of 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.

6. Click the Performance & SQL , Transaction , and Storage and Cache tabs to view the corresponding monitoring data of the tenant.

   For more information about monitoring metrics, see Metrics. If multiple OBServers are specified as the statistical range, their average value of each metric is displayed.

   • Click the Performance & SQL tab to view the SQL execution performance.

   • Click the Transaction tab to view the transaction performance.

   • Click the Storage and Cache tab to view the performance metrics related to storage and cache.

   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.

   

   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 1, 2, and 3 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 Performance & SQL tab supports the following drill-down dimensions: tenant > OBServer

• The Transaction tab supports the following drill-down dimensions: tenant > OBServer

• The Storage and Cache tab supports the following drill-down dimensions: tenant > OBServer

The preceding features 1, 2, and 3 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 one 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 drill down to other dimensions.

3. You can directly go to the Performance Monitoring page of the host from the trend chart.

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