View OBProxy clusters list|V4.2.1| docs|Distributed Database

View OBProxy clusters list

Last Updated：2023-11-23 07:52:12 Updated

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 . You can filter OBProxy clusters by Status column.

The Actions column provides the Add OBProxy, Take over an 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, Take over an OBProxy, Add an OBProxy, Delete an OBProxy cluster.

10131630

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, 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.

10131632

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.
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.