Note
This view is available starting with V4.4.1.
Purpose
This view displays the usage of HMS Catalog clients for all tenants.
Columns
| Column | Type | Nullable | 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 | The ID of the tenant. Valid values:
|
| CATALOG_ID | bigint(20) | NO | The ID of a catalog under the tenant. |
| TOTAL_CLIENTS | bigint(20) | NO | The total number of clients created for the catalog under the tenant. |
| IN_USE_CLIENTS | bigint(20) | NO | The number of clients currently in use for the catalog under the tenant. |
| IDLE_CLIENTS | bigint(20) | NO | The number of idle clients for the catalog under the tenant. |
Sample query
Query the usage of HMS Catalog clients for all tenants in the sys tenant.
obclient> SELECT * FROM oceanbase.GV$OB_HMS_CLIENT_POOL_STAT;
The query result is as follows:
+----------------+----------+-----------+------------+---------------+----------------+--------------+
| SVR_IP | SVR_PORT | TENANT_ID | CATALOG_ID | TOTAL_CLIENTS | IN_USE_CLIENTS | IDLE_CLIENTS |
+----------------+----------+-----------+------------+---------------+----------------+--------------+
| xx.xxx.xxx.xxx | 17131 | 1004 | 500006 | 1 | 0 | 1 |
| xx.xxx.xxx.xxx | 17131 | 1004 | 500005 | 1 | 0 | 1 |
+----------------+----------+-----------+------------+---------------+----------------+--------------+
2 rows in set