Views related to the connection count
The GV$OB_KV_CONNECTIONS view displays the number of active KV connections of the current tenant.
MySQL [oceanbase]> select * from GV$OB_KV_CONNECTIONS;
+-----------+---------+--------+----------------+----------+----------------+-------------+----------------------------+----------------------------+
| TENANT_ID | USER_ID | DB_ID | SVR_IP | SVR_PORT | CLIENT_IP | CLIENT_PORT | FIRST_ACTIVE_TIME | LAST_ACTIVE_TIME |
+-----------+---------+--------+----------------+----------+----------------+-------------+----------------------------+----------------------------+
| 1 | 200001 | 500001 | 11.162.xx.xx | 54302 | 30.182.xx.xx | 59346 | 2024-05-31 22:23:17.359210 | 2024-05-31 22:23:17.359210 |
+-----------+---------+--------+----------------+----------+----------------+-------------+----------------------------+----------------------------+
Views related to TTL
View name |
Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | Displays the ongoing time-to-live (TTL) tasks in all tenants. You can query this view only from the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in all tenants. You can query this view only from the sys tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the ongoing TTL tasks in the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in the current tenant. |