建业务租户后,sys租户QPS增长6000+,目前9000+
TOP SQL:
select
/*+query_timeout(2000000)*/
a .svr_ip,
a .svr_port,
a .tenant_id,
a .ls_id,
a .role,
nvl(b.weak_read_scn, ?) as weak_read_scn,
nvl(b.migrate_status, ?) as migrate_status,
nvl(b.tx_blocked, ?) as tx_blocked
from
oceanbase.__all_virtual_ls_meta_table a
left join oceanbase.__all_virtual_ls_info b on a .svr_ip = b.svr_ip
and a .svr_port = b.svr_port
and a .tenant_id = b.tenant_id
and a .ls_id = b.ls_id;
SELECT
*
FROM
__all_ls_meta_table
WHERE
tenant_id
SELECT
*
FROM
__all_ls_meta_table
WHERE
tenant_id = ?
ORDER BY
tenant_id,
ls_id,
svr_ip,
svr_port