Performance monitoring is one of the core modules of obshell Dashboard. It provides real-time monitoring capabilities for OceanBase clusters across multiple dimensions, including cluster, host, tenant, OBServer, and unit levels. This helps you quickly identify performance bottlenecks and optimize system resource usage.
Access path
Log in to the obshell console and enter the address, username, and password of the Prometheus server. Then, click Enable to go to the Performance Monitoring page. You can use the existing Prometheus server to enable performance monitoring. If you have not deployed a Prometheus server, we recommend that you use obd to deploy one. You can click OceanBase Cluster or OceanBase Database Tenant in the upper-right corner of the Performance Monitoring page to go to the corresponding tab.
Note
You need to enter the address, username, and password of the Prometheus server only when you log in to the Performance Monitoring page for the first time.
OceanBase cluster
The OceanBase cluster page displays data in five dimensions: cluster, host, tenant, OBServer, and unit. By default, it displays data in the cluster dimension of the database performance section. The monitoring items supported in different dimensions vary.
Page |
Monitoring items |
|---|---|
| Database performance | The database performance section displays data in four dimensions: cluster, tenant, OBServer, and unit. It displays charts of the following performance metrics over different periods of time: QPS, SQL response time, TPS, Transaction Response Time, Sessions, Request Waiting Queue Time, number of transaction logs, size of transaction logs, transaction log time, number of physical I/O operations, physical I/O time, physical I/O throughput, and number of transactions. |
| Host performance | The host performance section displays data in two dimensions: cluster and host. It displays charts of the following performance metrics: Linux system load, CPU Utilization, Memory, Memory Usage, IOPS, I/O Latency, IO throughput, and network throughput. |
The following example describes how to view data in the cluster dimension of the database performance section.
Procedure
Log in to the obshell console.
In the left-side navigation pane, click Performance Monitoring.
Note
You need to enter the address, username, and password of Prometheus for the first login. If Prometheus is not deployed, we recommend that you use obd to install and deploy it.
The Database Performance tab of the OceanBase cluster appears.
In the Data Filtering section, configure the data filtering conditions.
FilterDescriptionRefresh The Refresh Frequency of the performance data needs to be updated. You can hover the pointer over the Close button and select a refresh frequency from the drop-down list. The refresh frequency can be Off,5s,10s, or30s. The default value isOff. You can also click the Refresh button at any time to refresh the data.Time Range You can customize the time range. - Click the left side to select monitoring information for a period of time before the current time. For example, if you click
Last 30 Minutes, the monitoring information for the last 30 minutes will be displayed. By default, the information for the last 1 hour is displayed. You can select a different time range as needed. - On the right side, you can manually enter the date and time, or select the date from the calendar below and the time by dragging the mouse.
Zone By default, the performance data of all zones is displayed. You can click the All button after the Zone field to select a zone from the drop-down list to view the performance data of the selected zone. OBServer By default, the performance data of all OBServer nodes is displayed. You can click the All button after the OBServer field to select an OBServer node from the drop-down list to view the performance data of the selected node. - Click the left side to select monitoring information for a period of time before the current time. For example, if you click
The Database Performance tab displays the database performance monitoring data of the OceanBase cluster in four dimensions: cluster, tenant, OBServer, and unit, at different times. The data is displayed in charts that show the changes of multiple performance metrics, including QPS, SQL Response Time, TPS, Transaction Response Time, Sessions, Request Waiting Queue Time, Number of Transactions, Transaction Log Volume, Transaction Log Time, Number of Physical I/Os, Physical I/O Time, Physical I/O Throughput, and Number of Transactions.
The following features help you view and analyze the performance monitoring data in the trend chart. You can refer to the image and the following descriptions.
- Hover the pointer over the question mark icon to view the description of the corresponding monitoring item. Hover the pointer over any position on the trend chart to view the details of the line chart. You can click ▲ and ▼ in the upper-right corner of the trend chart to navigate to the previous or next page.
In the OBServer Dimension and Unit Dimension tabs under the Database Performance tab, hover the pointer over any position on the trend chart to view the IP:Port information of the corresponding performance data.
In the Host Dimension tab under the Host Performance tab, hover the pointer over any position on the trend chart to view the IP information of the corresponding performance data.
You can perform operations on specific monitoring items. For example, you can click the red box in the following figure to hide the corresponding line, or click the blue box in the following figure to display only the line.
You can also zoom in on the monitoring chart. Click the magnifying glass icon in the upper-right corner of the chart to view the zoomed-in chart in a pop-up window.
- In non-auto-refresh mode: Click the magnifying glass icon in the upper-right corner of the chart to view the zoomed-in chart in a pop-up window. In the pop-up window, you can view the monitoring data and select a time range to view the corresponding data. The time range in the outer layer is passed to the pop-up window. If you change the time range in the outer layer, the change is automatically applied to the opened pop-up window.
After you select a time range, a refresh button appears. You can manually refresh the data.
- In auto-refresh mode: Click the magnifying glass icon in the upper-right corner of the chart to view the zoomed-in chart in a pop-up window. The pop-up window automatically refreshes the data based on the refresh frequency in the outer layer. The time range selector is hidden in the pop-up window, and you cannot control the time range separately.
OceanBase tenants
The obshell Dashboard allows you to view the performance, SQL, transaction, storage, and cache monitoring data of OceanBase tenants from the tenant and unit dimensions. You can view the monitoring data from the following two entry points:
Entry 1: Log in to the obshell Dashboard. In the left-side navigation pane, click Tenants. In the Tenants page, click the name of the target tenant to go to the management page of the tenant. In the left-side navigation pane, click Performance Monitoring. The system automatically displays the Performance and SQL tab.
Entry 2: Log in to the obshell Dashboard. In the left-side navigation pane, click Performance Monitoring. In the OceanBase Cluster section, click OceanBase Database Tenant. The Performance and SQL tab is displayed.
Note
When you select the Performance Monitoring tab from the Tenant Management page, you can view only the monitoring data of the current tenant.
The OceanBase tenant page displays the performance data of OceanBase tenants from the tenant and unit dimensions in the Performance and SQL, Transaction, and Storage and Cache tabs. By default, the Performance and SQL tab is displayed. The monitoring metrics supported in different tabs are different.
Tab |
Monitoring metrics |
|---|---|
| Performance and SQL | Displays charts of the following metrics: QPS, Response Time, SQL Execution Plan Category, SQL Execution Time, Sessions, Waiting Time, Waiting Event Duration, Request Waiting Queue, Request Waiting Queue Time, CPU Consumption of Tenant, Thread Usage of Tenant, Memory Usage, MEMStore Usage Percentage, RPC Packet Duration, RPC Packet Throughput, Number of Open Cursors, RPC Request Success Rate, GTS Requests, RPC Network Latency, and RPC Delivery Failure. |
| Transactions | Displays charts of the following metrics: TPS, Transaction Response Time, Transaction Response Time Details, Transaction Rollback Ratio, Number of Transaction Logs, Transaction Log Volume, Transaction Log Duration, Number of Transaction Lock Waits, Average Transaction Lock Wait Time, Number of Transactions, and MemStore Lock Request Success Rate. |
| Storage and Cache | Displays charts of the following metrics: MEMStore, Physical I/O Requests, Physical I/O Duration, Physical I/O Throughput, Cache Size, Cache Hit Rate, Number of Cache Requests, Log Disk, Log Disk Percentage, Vector Memory, and Vector Memory Percentage. |
The following example describes how to view the monitoring data of OceanBase tenants from Entry 2.
Procedure
Log in to the obshell console.
In the left-side navigation pane, choose Performance Monitoring. The OceanBase Cluster tab appears.
Click the OceanBase Database Tenant tab.
In the Data Filtering section, configure the filtering conditions for the monitoring data.
FilterDescriptionRefresh The Refresh Frequency of the performance data needs to be updated. You can hover the pointer over the Close button and select the refresh frequency from the drop-down list. The refresh frequency can be set to Off,5s,10s, or30s. By default, it is set toOff. You can also click the Refresh button at any time to refresh the data.Time range You can customize the time range. - Click the left side to select the monitoring information for a period of time before the current time. For example, if you click
Last 30 Minutes, the monitoring information for the last 30 minutes is displayed. By default, the information for the last hour is displayed. You can select the time range as needed. - The right side contains the date and time. You can manually enter the date or select it from the calendar below. You can manually enter the time or select it by sliding the pointer.
Tenant By default, the performance data of the sys tenant is displayed. You can click the Tenant field to select the performance data of other tenants. Zone By default, the performance data of all zones is displayed. You can click the All button in the drop-down list of the Zone field to select a zone to view its performance data. OBServer By default, the performance data of all OBServer nodes is displayed. You can click the All button in the drop-down list of the OBServer field to select an OBServer node to view its performance data. - Click the left side to select the monitoring information for a period of time before the current time. For example, if you click
By default, the Performance & SQL tab of the tenant dimension is displayed, and the charts of the following metrics are displayed: QPS, Response Time, SQL Execution Plan Category, SQL Execution Time, Sessions, Waiting Time, Waiting Event Duration, Request Waiting Queue, Request Waiting Queue Time, CPU Consumption of Tenant, Thread Usage of Tenant, Memory Usage, MEMStore Usage Percentage, RPC Packet Duration, RPC Packet Throughput, Number of Open Cursors, RPC Request Success Rate, GTS Requests, RPC Network Latency, and RPC Delivery Failure.
The following features help you view and analyze the performance monitoring data in the trend chart. You can understand them by referring to the images and the following descriptions.
- Hover the pointer over the question mark icon to view the description of the corresponding monitoring item. Hover the pointer over any position in the chart to view the details of the line chart. You can click ▲ and ▼ in the upper-right corner to navigate to the previous or next page.
In the Unit Dimension tab, hover the pointer over any position in the chart to view the IP:Port information of the corresponding performance data.
You can perform operations on specific monitoring items. For example, you can click the red box in the following figure to hide the corresponding line, or click the blue box to display only the line.
You can also zoom in on the chart. Click the magnifier icon in the upper-right corner of the chart to view the zoomed-in chart in the dialog box.
- If automatic refresh is not enabled: Click the magnifier icon in the upper-right corner of the chart to open the zoomed-in dialog box. In the dialog box, you can view the monitoring data and select a time range to view the corresponding data. The outer time range is passed to the zoomed-in dialog box. Changing the outer time range automatically applies to the opened dialog box.
After you select a time range, a refresh button appears. You can manually refresh the data.
- If automatic refresh is enabled: Click the magnifier icon in the upper-right corner of the chart to open the zoomed-in dialog box. The dialog box automatically refreshes the data based on the outer refresh frequency. The time range selector is hidden in the zoomed-in dialog box, and you cannot control the time range separately.