通过tenant_id查到到租户名称

AI 与应用开发者专区
#1

SELECT * FROM oceanbase.gv$tenant; --3.1.2才有
MySQL [oceanbase]> select gmt_create ,gmt_modified ,tenant_id,zone_list ,primary_zone,locked,status from __all_tenant;
±---------------------------±---------------------------±----------±------------------±-------------±-------±-------+
| gmt_create | gmt_modified | tenant_id | zone_list | primary_zone | locked | status |
±---------------------------±---------------------------±----------±------------------±-------------±-------±-------+
| 2023-07-29 13:32:08.850362 | 2023-07-29 13:32:08.850362 | 1 | zone1;zone2;zone3 | RANDOM | 0 | NORMAL |
| 2023-07-31 12:54:15.616507 | 2023-07-31 12:54:53.906537 | 1001 | zone1;zone2;zone3 | RANDOM | 0 | NORMAL |
| 2023-07-31 12:54:15.627553 | 2023-07-31 12:54:54.484120 | 1002 | zone1;zone2;zone3 | RANDOM | 0 | NORMAL |
±---------------------------±---------------------------±----------±------------------±-------------±-------±-------+

想查找到tenant_id =1001对应的是哪个租户(租户名称 )

SELECT * FROM oceanbase.gv$tenant; --3.1.2才有

#2

4.x上修改了内部表，可以通过视图查看

select * from oceanbase.DBA_OB_TENANTS;
#3

我用的是mysql模式 没有这个视图

#4

select a.svr_ip,a.svr_port,a.tenant_id,b.tenant_name from __all_virtual_unit a,dba_ob_tenants b where a.tenant_id=b.tenant_id;

#5

谢谢老师，我找到了对应视图