The OceanBase Cloud Platform (OCP) console allows you to view the performance monitoring data of an OceanBase Database Proxy (ODP) cluster, including service monitoring information and system monitoring information.
Service monitoring
Log on to the OCP console.
In the left-side navigation pane, click OBProxy.
In the ODP cluster list, click the ODP cluster whose performance data you want to view. Then, go to the Service Monitoring tab on the Performance Monitoring page.
On the Service Monitoring tab, you can set the unit of the statistical period to Minute or Second. You can also select Last 30 Minutes, Last 1 Hour, or Custom Time for Duration.
If you toggle on Auto Refresh, the system updates data once every 10 seconds.
In the Overview section, you can view the performance monitoring data of the ODP cluster.
You can click View All in the upper-right corner to view the transaction count per second, requests, connected clients, connected servers, SQL processing time, error response packets per second, routing table, and network request bytes.
In the Connected OceanBase Cluster Data section, view the performance of interaction between the current ODP cluster and OceanBase clusters that use the ODP cluster.
As for each performance monitoring metric, you can view its maximum, minimum, and average values. You can click Column Management to select the metrics to display. The metrics include transactions per second, requests, connected clients, connected servers, SQL processing time, error response packets per second, routing table, and network request bytes.
In the OceanBase IP Address section, you can view the performance of all ODPs in the current ODP cluster, and the maximum, minimum, and average values of each metric. You can click Column Management to select the metrics to display. The metrics include transactions per second, requests, connected clients, connected servers, SQL processing time, error response packets per second, routing table, and network request bytes.
System monitoring
Log on to the OCP console.
In the left-side navigation pane, click OBProxy.
In the ODP cluster list, click the ODP cluster whose performance data you want to view. Then, go to the System Monitoring tab on the Performance Monitoring page.
On the System Monitoring tab, you can set the unit of the statistical period to Minute or Second. You can also select Last 30 Minutes, Last 1 Hour, or Custom Time for Stat Period.
Toggle on Auto Refresh to view data updated in real time.
In the Overview section, click View All in the upper-right corner to view the Linux system load, CPU utilization, average I/O requests per second, average I/O time consumption, average I/O data amount, network throughput rate, memory, and disk usage.
In the OceanBase IP Address section, you can view the maximum, minimum, and average values of each metric. You can click Column Management to select the metrics to display. The metrics include Linux system load, CPU utilization, average I/O requests per second, average I/O time consumption, average I/O data amount, network throughput rate, memory, and disk usage.
