This topic describes the OBKV-Redis performance metrics related to queries per second (QPS), namely the number of SQL statements 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 statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| all | obkv_redis_sql_all_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191643",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191631",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191589",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191595",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191509",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191517",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191541",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191557",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191643, 191631, 191589, 191595, 191509, 191517, 191541, 191557) and (con_id > 1000 or con_id = 1)
set
Definition
The number of SET statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| set | obkv_redis_sql_set_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191643",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191643) and (con_id > 1000 or con_id = 1)
get
Definition
The number of GET statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| get | obkv_redis_sql_get_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191631",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191631) and (con_id > 1000 or con_id = 1)
hset
Definition
The number of HSET statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| hset | obkv_redis_sql_hset_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191589",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191589) and (con_id > 1000 or con_id = 1)
hget
Definition
The number of HGET statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| hget | obkv_redis_sql_hget_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191595",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191595) and (con_id > 1000 or con_id = 1)
lpush
Definition
The number of LPUSH statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| lpush | obkv_redis_sql_lpush_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191509",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191509) and (con_id > 1000 or con_id = 1)
lpop
Definition
The number of LPOP statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| lpop | obkv_redis_sql_lpop_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191517",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191517) and (con_id > 1000 or con_id = 1)
sadd
Definition
The number of SADD statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| sadd | obkv_redis_sql_sadd_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191541",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191541) and (con_id > 1000 or con_id = 1)
zadd
Definition
The number of ZADD statements processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| zadd | obkv_redis_sql_zadd_count | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="191557",@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (191557) and (con_id > 1000 or con_id = 1)