統計情報
以下の例では、メトリクスIDが190000より大きく190800より小さい範囲の、OBKV-Table関連の監視メトリクスを照会します。
MySQL [oceanbase]> SELECT distinct class,stat_id,name, value 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の意味の違いは以下のとおりです：
- Multi：同じ種類の単一操作をまとめたバッチです。
- Batch Scan：複数のScan操作をまとめたバッチです。
- Batch Hybrid：異なる種類の単一操作などを組み合わせたバッチです。
各パラメータの説明は以下のとおりです：
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 hybrid execute time | ハイブリッドバッチの実行総時間 |
| batch hybrid insert_or_update rows | ハイブリッドバッチ操作の総行数 |