This topic describes the OBKV-Table 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_table_sql_all_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190105",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190405",@LABELS}[@INTERVAL])) by (@GBLABELS) R_FILL_0_ADD sum(rate(ob_sysstat{stat_id="191305",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190105",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190405",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191305",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190205",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190505",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190005",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190903",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190906",@LABELS}[@INTERVAL])) by (@GBLABELS) R_FILL_0_ADD sum(rate(ob_sysstat{stat_id="190707",@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 (190105, 190405, 191305, 190105, 190405, 191305, 190205, 190505, 190005, 190903, 190906, 190707) 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 (190105, 190405, 191305, 190105, 190405, 191305, 190205, 190505, 190005, 190903, 190906, 190707) and (con_id > 1000 or con_id = 1)
select
Definition
The number of SELECT statement lines processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| select | obkv_table_sql_select_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190005",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190903",@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 (190005, 190903) 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 (190005, 190903) and (con_id > 1000 or con_id = 1)
insert
Definition
The number of INSERT statement lines processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| insert | obkv_table_sql_insert_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190105",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="190405",@LABELS}[@INTERVAL])) by (@GBLABELS) R_FILL_0_ADD sum(rate(ob_sysstat{stat_id="191305",@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 (190105, 190405, 191305) 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 (190105, 190405, 191305) and (con_id > 1000 or con_id = 1)
update
Definition
The number of UPDATE statement lines processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| update | obkv_table_sql_update_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190305",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191105",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="191205",@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 (190305, 191105, 191205) 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 (190305, 191105, 191205) and (con_id > 1000 or con_id = 1)
replace
Definition
The number of REPLACE statement lines processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| replace | obkv_table_sql_replace_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190505",@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 (190505) 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 (190505) 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_table_sql_delete_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190205",@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 (190205) 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 (190205) and (con_id > 1000 or con_id = 1)
query and mutate
Definition
The number of query and mutation statement lines processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| query and mutate | obkv_table_sql_query_mutate_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190906",@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 (190906) 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 (190906) and (con_id > 1000 or con_id = 1)
other
Definition
The number of lines of other statements, such as data definition language (DDL), data control language (DCL), and data transaction language (DTL) statements, processed per second.
Description
| Metric category | Metric name | Unit |
|---|---|---|
| other | obkv_table_sql_other_row | times/s |
Calculation expression
sum(rate(ob_sysstat{stat_id="190707",@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 (190707) 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 (190707) and (con_id > 1000 or con_id = 1)