OBProxy can forward user-initiated data access requests to the corresponding OBServer. OBProxy allows you to create an OBProxy cluster, view the OBProxy cluster information, and view the OBProxy monitoring information.
Clusters
The Clusters list contains the following columns: OBProxy Cluster Name, Deployment Mode, Connectable OceanBase Clusters, Access URL, Port, Version, Created At , and Actions . The Actions column provides the Add OBProxy and Delete options. Click a cluster name in the OBProxy Cluster Name column. The details page of the corresponding cluster appears. For more information, see Create an OBProxy cluster, Add an OBProxy, Delete an OBProxy cluster.
Top 5 Monitoring Metrics
In the Top 5 Monitoring Metrics section, you can view statistics such as TPS, QPS, Client Connections, Server Connections, SQL Response Time, Routing Tables , and Net bytes . You can click Last Hour, Last 24 Hours , and Last 7 Days in the drop-down list to view data of the corresponding time range.
| Parameter |
Description |
| TPS |
The number of transactions processed per second. |
| QPS |
Queries per second.
- commit: Commit queries per second.
- delete: Delete queries per second.
- insert: Insert queries per second.
- large: Large queries per second.
- select: Select queries per second.
- sequence: Sequence queries per second.
- slow: Slow queries per second.
- update: Update queries per second.
- others: Other requests per second.
|
| Client Connections |
The number of client connections. |
| Server Connections |
The number of server connections. |
| SQL Response Time |
The time spent on processing an SQL statement.
- commit: The average time, in ms, spent on processing a Commit query.
- delete: The average time, in ms, spent on processing a Delete query.
- insert: The average time, in ms, spent on processing an Insert query.
- prepare_send_request: The average time, in ms, spent on preparing a query for sending.
- server_process_request: The average time, in ms, spent on processing a query by the server.
- select: The average time, in ms, spent on processing a Select query.
- sequence: The average time, in ms, spent on processing a Sequence query.
- update: The average time, in ms, spent on processing an Update query.
- others: The average time, in ms, spent on processing a query of other types.
|
| Routing Table |
Information about routing tables.
- hit: The average number of routing table hits per second.
- partition: The average number of partition entry queries per second.
- route: The average number of route entry queries per second.
- success: The average number of successful routing table queries per second.
- table: The average number of table entry queries per second.
|
| Net bytes |
The data volume of network requests in the unit of bytes.
- client_request: The total size of client requests in the unit of bytes.
- client_response: The size of client responses in the unit of bytes.
- server_request: The size of server requests in the unit of bytes.
- server_response: The size of server responses in the unit of bytes.
|
