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, Accessible OceanBase Cluster, Access IP Address, Access 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 or Accessible OceanBase Cluster column. The details page of the corresponding cluster appears. For more information, see Create an OBProxy cluster, Add an OBProxy, Delete an OBProxy cluster.
OBProxy Monitoring Top 5
In the OBProxy Monitoring Top 5 section, you can view statistics such as TPS, QPS, Client Connections, Server Connections, SQL Response Time, Error Packets, Routing Tables , and 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. |
| Error Package |
The number of error response packages per second. error: The average number of error logs per second.warn: The average number of warning logs per second. |
| 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. |
| 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. |
