This topic describes the OBKV-HBase performance metrics related to the average number of SQL statement lines processed per second within a tenant. You can specify a statistical period to query these metrics of a tenant in a single zone or on a single OBServer node.
all
Definition
The number of SQL statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| all | obkv_hbase_sql_all_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191003",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191006",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191009",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191012",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191015",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191018",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191021",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191024",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191003, 191006, 191009, 191012, 191015, 191018, 191021, 191024) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191003, 191006, 191009, 191012, 191015, 191018, 191021, 191024) and (con_id > 1000 or con_id = 1)
put
Definition
The number of Put statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| put | obkv_hbase_sql_put_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191006",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191006) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191006) and (con_id > 1000 or con_id = 1)
delete
Definition
The number of DELETE statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| delete | obkv_hbase_sql_delete_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191009",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191009) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191009) and (con_id > 1000 or con_id = 1)
append
Definition
The number of Append statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| append | obkv_hbase_sql_append_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191012",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191012) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191012) and (con_id > 1000 or con_id = 1)
increment
Definition
The number of Increment statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| increment | obkv_hbase_sql_increment_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191015",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191015) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191015) and (con_id > 1000 or con_id = 1)
checkAndPut
Definition
The number of checkAndPut statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| checkAndPut | obkv_hbase_sql_checkAndPut_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191018",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191018) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191018) and (con_id > 1000 or con_id = 1)
checkAndDelete
Definition
The number of checkAndDelete statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| checkAndDelete | obkv_hbase_sql_checkAndDelete_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191021",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191021) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191021) and (con_id > 1000 or con_id = 1)
hybrid batch
Definition
The number of hybrid batch statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| hybrid batch | obkv_hbase_sql_hybrid_batch_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191024",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191024) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191024) and (con_id > 1000 or con_id = 1)
scan
Definition
The number of scan statement lines processed per second.
Description
Metric category |
Metric name |
Unit |
|---|---|---|
| scan | obkv_hbase_sql_scan_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191003",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database of a version earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191003) and (con_id > 1000 or con_id = 1)OceanBase Database V4.0 and later
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191003) and (con_id > 1000 or con_id = 1)