This topic describes the MemStore usage monitoring metrics within an OceanBase Database tenant. You can specify a statistical period to query the MemStore usage in a single zone or that on a single OBServer node of an OceanBase Database tenant.
Memstore_percent
Definition
The usage of MemStore within a tenant in the specified statistical period.
Description
| Metric | Metric name | Unit |
|---|---|---|
| memstore_percent | Memstore_percent | % |
Expression
100 * sum(ob_sysstat{stat_id=“130001”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130004”,@LABELS}) by (@GBLABELS)
SQL statements for metric collection
If you use OceanBase Database of a version earlier than V4.0, execute the following statement:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (130001, 130004) and (con_id > 1000 or con_id = 1) and class < 1000If you use OceanBase Database V4.0 or later, execute the following statement:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (130001, 130004) and (con_id > 1000 or con_id = 1) and class < 1000
Active_memstore_percent
Definition
The usage of MemStore within a tenant in the specified statistical period to the threshold that triggers a freeze.
Description
| Metric | Metric name | Unit |
|---|---|---|
| active_memstore_percent | Active_memstore_percent | % |
Expression
100 * sum(ob_sysstat{stat_id=“130000”,@LABELS}) by (@GBLABELS) / sum(ob_sysstat{stat_id=“130002”,@LABELS}) by (@GBLABELS)
SQL statements for metric collection
If you use OceanBase Database of a version earlier than V4.0, execute the following statement:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (130000, 130002) and (con_id > 1000 or con_id = 1) and class < 1000If you use OceanBase Database V4.0 or later, execute the following statement:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (130000, 130002) and (con_id > 1000 or con_id = 1) and class < 1000