Collect MemStore information of a tenant

Description

You can query MemStore information of the specified tenant from the __all_virtual_tenant_memstore_info table.

Statement

• OceanBase Database V4.0.0 or later:

  SELECT
    m.svr_ip,
    m.svr_port,
    round(m.active_span / 1024 / 1024 / 1024, 5) active_gb,
    round(m.freeze_trigger / 1024 / 1024 / 1024, 5) trigger_gb,
    round(m.memstore_used / 1024 / 1024 / 1024, 5) used_gb,
    round(m.memstore_limit / 1024 / 1024 / 1024, 5) limit_gb,
    m.freeze_cnt freeze_count
  FROM
    __all_virtual_tenant_memstore_info m
    INNER JOIN __all_tenant t ON t.tenant_id = m.tenant_id
  WHERE
    t.tenant_name = ?
  

• OceanBase Database of a version earlier than V4.0.0:

  SELECT
    m.svr_ip,
    svr_port,
    round(m.active_memstore_used / 1024 / 1024 / 1024, 5) active_gb,
    round(m.major_freeze_trigger / 1024 / 1024 / 1024, 5) trigger_gb,
    round(m.total_memstore_used / 1024 / 1024 / 1024, 5) used_gb,
    round(m.memstore_limit / 1024 / 1024 / 1024, 5) limit_gb,
    m.freeze_cnt freeze_count
  FROM
    __all_virtual_tenant_memstore_info m
    INNER JOIN __all_tenant t ON t.tenant_id = m.tenant_id
  WHERE
    t.tenant_name = ?