Note
For OceanBase Database V4.6.x, this view is introduced starting with V4.6.0.
Purpose
The V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT view displays Catalog client pool information for the OBServer that executes the query.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica resides. |
| SVR_PORT | bigint(20) | NO | The port of the node where the replica resides. |
| TENANT_ID | bigint(20) | NO | The tenant ID:
|
| CLIENT_TYPE | varchar(128) | NO | The client type. |
| CATALOG_ID | bigint(20) | NO | The ID of a catalog in the tenant. |
| URI | varchar(4096) | NO | The server address to which the client connects. |
| TOTAL_CLIENTS | bigint(20) | NO | The total number of clients created for the catalog corresponding to CATALOG_ID under the tenant corresponding to TENANT_ID. |
| IN_USE_CLIENTS | bigint(20) | NO | The number of clients in use for the catalog corresponding to CATALOG_ID under the tenant corresponding to TENANT_ID. |
| IDLE_CLIENTS | bigint(20) | NO | The number of idle clients for the catalog corresponding to CATALOG_ID under the tenant corresponding to TENANT_ID. |
Sample query
Query the Catalog client pool information for the OBServer that executes the query.
obclient> SELECT * FROM oceanbase.V$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