Statistics
You can use the following example to query the monitoring metrics of OBKV-Table, with metric IDs in the range of (190000, 190800).
MySQL [oceanbase]> SELECT distinct class,stat_id,name, value FROM gv$sysstat WHERE stat_id > 190000 AND stat_id < 190800;
The query result is as follows:
+-------+---------+---------------------------------------+------------+
| 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 |
+-------+---------+---------------------------------------+------------+
The semantics of Batch and Multi in the metric names are described as follows:
- Multi refers to batches of single operations of the same type.
- Batch Scan refers to batches of multiple scans.
- Batch Hybrid refers to mixed batches, such as batches of single operations of different types.
The metrics are described as follows:
Name |
Description |
|---|---|
| single retrieve execute count | Number of GET requests. |
| single retrieve execute time | Total execution time of GET. |
| multi retrieve execute count | Number of multi-get operations. |
| multi retrieve execute time | Total execution time of multi-get. |
| multi retrieve rows | Total number of rows in multi-get operations. |
| single insert execute count | Number of INSERT executions. |
| single insert execute time | Total execution time of INSERT. |
| multi insert execute count | Number of multi-insert executions. |
| multi insert execute time | Total execution time of multi-insert. |
| multi insert rows | Total number of rows in multi-insert operations. |
| single delete execute count | Number of DELETE operations. |
| single delete execute time | Total execution time of DELETE. |
| multi delete execute count | Number of multi-delete executions. |
| multi delete execute time | Total execution time of multi-delete. |
| multi delete rows | Total number of rows deleted by multi-delete operations. |
| single update execute count | Number of UPDATE operations. |
| single update execute time | Total execution time of UPDATE. |
| multi update execute count | Number of multi-update operations. |
| multi update execute time | Total execution time of multi-update. |
| multi update rows | Total number of rows in multi-update operations. |
| single insert_or_update execute count | Number of insert_or_update operations. |
| single insert_or_update execute time | Total execution time of insert_or_update. |
| multi insert_or_update execute count | Number of multi insert_or_update executions. |
| multi insert_or_update execute time | Total execution time of multi insert_or_update. |
| multi insert_or_update rows | Total number of rows in multi insert_or_update operations. |
| single replace execute count | Number of REPLACE operations. |
| single replace execute time | Total execution time of REPLACE. |
| multi replace execute count | Number of multi-replace executions. |
| multi replace execute time | Total execution time of multi-replace. |
| multi replace rows | Total number of rows in multi-replace operations. |
| batch retrieve execute count | Number of batch scan executions. |
| batch retrieve execute time | Total execution time of batch scan. |
| batch retrieve rows | Total number of rows scanned in batches. |
| batch hybrid execute count | Number of mixed batch executions. |
| batch hybrid execute time | Total execution time of mixed batches. |
| batch hybrid insert_or_update rows | Total number of rows in mixed batch operations. |