Performance monitoring is one of the core modules of the obshell Dashboard, providing real-time monitoring capabilities for OceanBase clusters across multiple dimensions such as cluster, host, tenant, OBServer, and unit. This helps you quickly identify performance bottlenecks and optimize system resource usage.
OceanBase cluster
The OceanBase cluster page displays data in five dimensions: cluster, host, tenant, OBServer, and unit. By default, the database performance metrics are displayed in the cluster dimension. Different dimensions support different monitoring metrics.
| Page | Monitoring item |
|---|---|
| Database performance | Database performance is displayed in four dimensions: cluster, tenant, OBServer, and unit. It shows the changes in charts of multiple performance metrics, including QPS, SQL response time, TPS, transaction response time, number of sessions, request waiting queue time, number of transaction logs, volume 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 | Host performance is displayed in two dimensions: cluster and host. It shows the changes in charts of multiple performance metrics, including Linux system load, CPU utilization, memory, memory utilization, IOPS, IO time, IO throughput, and network throughput. |
The following example describes how to view the database performance metrics in the cluster dimension.
Procedure
Log in to the obshell console.
In the left-side navigation pane, click Performance Monitoring.
Note
When you log in for the first time, you need to enter the address, username, and password of Prometheus. If you have not deployed Prometheus, we recommend that you use obd to install and deploy it.
The Database Performance tab of the OceanBase cluster appears by default.
In the Data Filtering section, configure the data filtering conditions.
Filter Description Refresh You can change the refresh frequency of the performance data. Hover the pointer over the Disable button and select a refresh frequency from the drop-down list. The options are Off,5s,10s, and30s. The default value isOff. You can also click Refresh at any time to refresh the data.Time Range You can customize the time range. - Click the left side to select monitoring information within a certain period before the current time. For example, click
Last 30 Minutesto view monitoring information within the last 30 minutes. By default, the last 1 hour of data is displayed. You can select other time ranges as needed. - On the right side, you can manually enter or select a date and time. You can also select a time by sliding the pointer.
Zone By default, the performance data of all zones is displayed. You can click the arrow next to the Zone field to select the performance data of a specific zone. OBServer By default, the performance data of all OBServer nodes is displayed. You can click the arrow next to the OBServer field to select the performance data of other OBServer nodes. - Click the left side to select monitoring information within a certain period before the current time. For example, click
The Database Performance tab displays the performance monitoring data of the OceanBase cluster in four dimensions: cluster, tenant, OBServer, and unit. The data is displayed in charts that show the changes in the QPS, SQL Response Time, TPS, Transaction Response Time, Session Count, Request Waiting Queue Time, Transaction Log Count, Transaction Log Volume, Transaction Log Time, Physical I/O Count, Physical I/O Time, Physical I/O Throughput, and Transaction Count metrics over different time periods.
You can use the following features to view and analyze the performance monitoring data in the trend chart.
- Hover the pointer over the question mark icon to view the description of the corresponding metric. Hover the pointer over any position on the chart to view the details of the line chart. You can click ▲ and ▼ in the upper-right corner to navigate through the pages.
You can perform operations on specific monitoring items. For example, clicking the red box in the following figure hides the corresponding line, while clicking the blue box displays only that line.
OceanBase tenants
The obshell Dashboard allows you to view performance data, SQL data, transaction data, storage data, and cache data of OceanBase tenants from the perspectives of tenants and units. You can access these views through the following two entry points:
Entry 1: Log in to the obshell Dashboard. In the left-side navigation pane, click Tenant Management. On the Tenant Management 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 Performance and SQL tab appears by default.
Entry 2: Log in to the obshell Dashboard. In the left-side navigation pane, click Performance Monitoring. On the OceanBase Cluster tab, click OceanBase Tenants at the top of the page to go to the Performance and SQL tab.
Note
If you access the Performance Monitoring page from the Tenant Management page, you can view only the monitoring data of the current tenant.
The OceanBase tenants page displays performance data of OceanBase tenants from the perspectives of tenants and units in the Performance and SQL, Transactions, and Storage and Cache tabs. By default, the Performance and SQL tab is displayed. The monitoring items supported in different tabs vary.
| Page | Metric |
|---|---|
| Performance and SQL | Displays charts showing changes in multiple performance metrics, including QPS, Response Time, SQL Execution Plan Category, SQL Execution Time, Number of Sessions, Wait Time, Wait Event Duration, Request Wait Queue, Request Wait Queue Duration, Tenant CPU Usage, Tenant Thread Usage, 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 Failures. |
| Transactions | Displays charts showing changes in multiple performance metrics, including 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 showing changes in multiple performance metrics, including MEMStore, Physical I/O Count, 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 metrics on the Performance and SQL tab of the Entry 2 page.
Procedure
Log in to the obshell console.
In the left-side navigation pane, choose Performance Monitoring. The OceanBase Cluster tab appears.
Click OceanBase Tenant.
In the Data Filtering section, configure the data filtering conditions.
Filtering Condition Description Refresh The refresh frequency of the performance data needs to be updated. You can hover the pointer over the Close button to select the refresh frequency from the drop-down list. The refresh frequency can be set to Off,5s,10s, or30s. The default value isOff. You can also click Refresh 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, click
Last 30 Minutesto view the monitoring information for the last 30 minutes. By default, the last 1 hour of data is displayed, and 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 sliding the pointer.
Tenant By default, the performance data of the sys tenant is displayed. You can click the options in the Tenant field to view the performance data of other tenants. Zone By default, the performance data of all zones is displayed. You can click the options in the Zone field to view the performance data of a specific zone. OBServer By default, the performance data of all OBServer nodes is displayed. You can click the options in the OBServer field to view the performance data of other OBServer nodes. - Click the left side to select the monitoring information for a period of time before the current time. For example, click
By default, the Performance and SQL tab is displayed, showing the changes in multiple performance metrics, including QPS, Response Time, SQL Execution Plan Category, SQL Execution Time, Session Count, Wait Time, Wait Event Duration, Request Waiting Queue, Request Waiting Queue Duration, Tenant CPU Usage, Tenant Thread Usage, Memory Usage, MEMStore Usage Percentage, RPC Packet Duration, RPC Packet Throughput, Open Cursors, RPC Request Success Rate, GTS Requests, RPC Network Latency, and RPC Delivery Failures.
The following features can help you view and analyze the performance monitoring data in the trend chart. You can refer to the image and the following description for better understanding.
- 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 monitoring chart to view the details of the line chart. Click ▲ and ▼ in the upper-right corner to navigate to the previous or next page.
You can perform operations on specific monitoring items. For example, clicking the red box in the following figure hides the corresponding line, and clicking the blue box shows only that line.