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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30082, 30083, 30084, 30085, 30086, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 60087, 80001, 80002, 80003, 80007, 80008, 80009, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200000, 200001, 200002, 200005, 200006, 200010, 200013) 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 (10000, 10001, 10002, 10003, 10004, 10005, 10006, 20000, 20001, 20002, 30000, 30001, 30002, 30005, 30006, 30007, 30008, 30009, 30010, 30011, 30012, 30013, 30080, 30081, 30200, 30201, 30204, 30205, 30208, 30209, 30212, 30213, 30216, 30217, 30220, 30221, 30222, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40018, 40019, 40030, 40116, 40117, 40118, 50000, 50001, 50002, 50004, 50005, 50008, 50009, 50010, 50011, 50037, 50038, 60000, 60001, 60002, 60003, 60004, 60005, 60019, 60020, 60021, 60022, 60023, 60024, 80040, 80041, 80057, 120000, 120001, 120008, 120009, 130000, 130001, 130002, 130004, 140002, 140003, 140005, 140006, 140012, 140013, 190001, 190002, 190003, 190004, 190005, 190101, 190102, 190103, 190104, 190105, 190201, 190202, 190203, 190204, 190205, 190301, 190302, 190303, 190304, 190305, 190401, 190402, 190403, 190404, 190405, 190501, 190502, 190503, 190504, 190505, 190601, 190602, 190603, 190701, 190702, 190707, 190801, 190901, 190902, 190903, 190904, 190905, 190906, 191001, 191002, 191003, 191004, 191005, 191006, 191007, 191008, 191009, 191010, 191011, 191012, 191015, 191016, 191017, 191018, 191019, 191020, 191021, 191022, 191023, 191024, 191101, 191102, 191103, 191104, 191105, 191201, 191202, 191203, 191204, 191205, 191301, 191302, 191303, 191304, 191305, 200002, 200005, 200006, 200010, 200013) and (con_id > 1000 or con_id = 1)
