This topic describes the OBKV-HBase performance metrics related to queries per second (QPS) within a tenant, including metrics for the SELECT, Put, DELETE, Append, Increment, CheckAndPut, checkAndDelete, hybrid batch, and scan statements, and metrics for all types of statements. 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 statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| all | obkv_hbase_sql_all_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191001",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191004",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191007",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191010",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190401",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191016",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191019",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191022",@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 (191001, 191004, 191007, 191010, 190401, 191016, 191019, 191022) 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 (191001, 191004, 191007, 191010, 190401, 191016, 191019, 191022) and (con_id > 1000 or con_id = 1)
put
Definition
The number of Put statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| put | obkv_hbase_sql_put_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191004",@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 (191004) 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 (191004) and (con_id > 1000 or con_id = 1)
delete
Definition
The number of DELETE statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| delete | obkv_hbase_sql_delete_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191007",@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 (191007) 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 (191007) and (con_id > 1000 or con_id = 1)
append
Definition
The number of Append statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| append | obkv_hbase_sql_append_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191010",@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 (191010) 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 (191010) and (con_id > 1000 or con_id = 1)
increment
Definition
The number of Increment statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| increment | obkv_hbase_sql_increment_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190401",@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 (190401) 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 (190401) and (con_id > 1000 or con_id = 1)
checkAndPut
Definition
The number of CheckAndPut statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| checkAndPut | obkv_hbase_sql_checkAndPut_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191016",@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 (191016) 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 (191016) and (con_id > 1000 or con_id = 1)
checkAndDelete
Definition
The number of checkAndDelete statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| checkAndDelete | obkv_hbase_sql_checkAndDelete_coun | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191019",@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 (191019) 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 (191019) and (con_id > 1000 or con_id = 1)
hybrid batch
Definition
The number of hybrid batch statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| hybrid batch | obkv_hbase_sql_hybrid_batch_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191022",@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 (191022) 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 (191022) and (con_id > 1000 or con_id = 1)
scan
Definition
The number of scan statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| scan | obkv_hbase_sql_scan_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191001",@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 (191001) 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 (191001) and (con_id > 1000 or con_id = 1)