Note
For V4.6.x, this view is available starting from V4.6.0.
Overview
The GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT view is used to obtain the catalog pooling information of all OBServer nodes.
Columns
Field |
Type |
Is NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica is located. |
| SVR_PORT | bigint(20) | NO | The port of the node where the replica is located. |
| TENANT_ID | bigint(20) | NO | Tenant ID:
|
| CLIENT_TYPE | varchar(128) | NO | Client type. |
| CATALOG_ID | bigint(20) | NO | The ID of a catalog under the tenant. |
| URI | varchar(4096) | NO | The IP address of the server to which the client connects. |
| TOTAL_CLIENTS | bigint(20) | NO | TENANT_IDUnder the corresponding tenantCATALOG_IDThe total number of clients created by the catalog. |
| IN_USE_CLIENTS | bigint(20) | NO | TENANT_IDUnder the corresponding tenantCATALOG_IDThe number of clients currently using the catalog. |
| IDLE_CLIENTS | bigint(20) | NO | TENANT_IDUnder the corresponding tenantCATALOG_IDNumber of idle clients in the catalog. |
Sample query
Query the catalog pooling information of all OBServer nodes.
obclient> SELECT * FROM oceanbase.GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT;
The query result is as follows:
+-------------+----------+-----------+-------------+------------+-------------------------------+---------------+----------------+--------------+
| SVR_IP | SVR_PORT | TENANT_ID | CLIENT_TYPE | CATALOG_ID | URI | TOTAL_CLIENTS | IN_USE_CLIENTS | IDLE_CLIENTS |
+-------------+----------+-----------+-------------+------------+-------------------------------+---------------+----------------+--------------+
| xx.xx.xx.xx | 10203 | 1004 | rest | 500005 | http://localhost:9001/iceberg | 1 | 0 | 1 |
+-------------+----------+-----------+-------------+------------+-------------------------------+---------------+----------------+--------------+
1 row in set