Skip to content

OBKV‐TableAPI 监控指标

Jump to bottom
vanson edited this page Sep 12, 2024 · 1 revision

查询指标项

可以通过以下示例查询OBKV-Table相关的监控指标, 指标id(190000, 190800)

MySQL [oceanbase]> select distinct class,stat_id,name, value_type from gv$sysstat where stat_id > 190000 and stat_id < 190800;
+-------+---------+---------------------------------------+------------+
| class | stat_id | name                                  | value_type |
+-------+---------+---------------------------------------+------------+
|  4096 |  190001 | single retrieve execute count         | ADD_VALUE  |
|  4096 |  190002 | single retrieve execute time          | ADD_VALUE  |
|  4096 |  190003 | multi retrieve execute count          | ADD_VALUE  |
|  4096 |  190004 | multi retrieve execute time           | ADD_VALUE  |
|  4096 |  190005 | multi retrieve rows                   | ADD_VALUE  |
|  4096 |  190101 | single insert execute count           | ADD_VALUE  |
|  4096 |  190102 | single insert execute time            | ADD_VALUE  |
|  4096 |  190103 | multi insert execute count            | ADD_VALUE  |
|  4096 |  190104 | multi insert execute time             | ADD_VALUE  |
|  4096 |  190105 | multi insert rows                     | ADD_VALUE  |
|  4096 |  190201 | single delete execute count           | ADD_VALUE  |
|  4096 |  190202 | single delete execute time            | ADD_VALUE  |
|  4096 |  190203 | multi delete execute count            | ADD_VALUE  |
|  4096 |  190204 | multi delete execute time             | ADD_VALUE  |
|  4096 |  190205 | multi delete rows                     | ADD_VALUE  |
|  4096 |  190301 | single update execute count           | ADD_VALUE  |
|  4096 |  190302 | single update execute time            | ADD_VALUE  |
|  4096 |  190303 | multi update execute count            | ADD_VALUE  |
|  4096 |  190304 | multi update execute time             | ADD_VALUE  |
|  4096 |  190305 | multi update rows                     | ADD_VALUE  |
|  4096 |  190401 | single insert_or_update execute count | ADD_VALUE  |
|  4096 |  190402 | single insert_or_update execute time  | ADD_VALUE  |
|  4096 |  190403 | multi insert_or_update execute count  | ADD_VALUE  |
|  4096 |  190404 | multi insert_or_update execute time   | ADD_VALUE  |
|  4096 |  190405 | multi insert_or_update rows           | ADD_VALUE  |
|  4096 |  190501 | single replace execute count          | ADD_VALUE  |
|  4096 |  190502 | single replace execute time           | ADD_VALUE  |
|  4096 |  190503 | multi replace execute count           | ADD_VALUE  |
|  4096 |  190504 | multi replace execute time            | ADD_VALUE  |
|  4096 |  190505 | multi replace rows                    | ADD_VALUE  |
|  4096 |  190601 | batch retrieve execute count          | ADD_VALUE  |
|  4096 |  190602 | batch retrieve execute time           | ADD_VALUE  |
|  4096 |  190603 | batch retrieve rows                   | ADD_VALUE  |
|  4096 |  190701 | batch hybrid execute count            | ADD_VALUE  |
|  4096 |  190702 | batch hybrid execute time             | ADD_VALUE  |
|  4096 |  190707 | batch hybrid insert_or_update rows    | ADD_VALUE  |
+-------+---------+---------------------------------------+------------+

指标项说明

参数说明: Name中Batch和Multi语义的区别

  1. Multi指同一类单操作的Batch
  2. Batch Scan, 多个Scan的Batch
  3. Batch Hybird, 混合batch, 比如不同类单操作的Batch
Name 描述
single retrieve execute count get的执行次数
single retrieve execute time get的执行总耗时
multi retrieve execute count multi get的执行次数
multi retrieve execute time multi get的执行总耗时
multi retrieve rows multi get操作的总行数
single insert execute count insert的执行次数
single insert execute time insert的执行总耗时
multi insert execute count multi insert的执行次数
multi insert execute time multi insert的执行总耗时
multi insert rows multi insert操作的总行数
single delete execute count delete的执行次数
single delete execute time delete的执行总耗时
multi delete execute count multi delete的执行次数
multi delete execute time multi delete的执行总耗时
multi delete rows multi delete操作的总行数
single update execute count update的执行次数
single update execute time update的执行总耗时
multi update execute count multi update的执行次数
multi update execute time multi update的执行总耗时
multi update rows multi update操作的总行数
single insert_or_update execute count insert_or_update的执行次数
single insert_or_update execute time insert_or_update的执行总耗时
multi insert_or_update execute count multi insert_or_update的执行次数
multi insert_or_update execute time multi insert_or_update的执行总耗时
multi insert_or_update rows multi insert_or_update操纵的总行数
single replace execute count replace的执行次数
single replace execute time replace的执行总耗时
multi replace execute count multi replace的执行次数
multi replace execute time multi replace的执行总耗时
multi replace rows multi replace操作的总行数
batch retrieve execute count Batch Scan的执行次数
batch retrieve execute time Batch Scan的执行总耗时
batch retrieve rows Batch Scan操作的总行数
batch hybrid execute count 混合batch的执行次数
batch hybrid execute time 混合batch的执行总耗时
batch hybrid insert_or_update rows 混合batch操作的总行数
Clone this wiki locally