This topic describes monitoring metrics related to the cache size within an OceanBase Database tenant. You can specify a statistical range to query statistics about the cache size in a single zone or on a single OBServer of an OceanBase Database tenant.
block_cache
Definition
The block cache size in the specified statistical range.
A block cache is similar to a buffer cache in Oracle Database and is used to store data blocks. To be specific, a block cache stores decompressed microblocks whose sizes swell after decompression.
Description
| Metric | Metric name | Unit |
|---|---|---|
| block_cache | block_cache_size | MB |
Calculation expression
sum(ob_cache_size_bytes{cache_name="user_block_cache",@LABELS}) by (@GBLABELS) / 1048576
row_cache
Definition
The row cache size in the specified statistical range.
A row cache stores data rows. After you call the Get or MultiGet method, the data rows returned may be stored in a row cache. This greatly facilitates the query of frequently queried rows, thus significantly improving the query performance.
Description
| Metric | Metric name | Unit |
|---|---|---|
| row_cache | row_cache_size | MB |
Calculation expression
sum(ob_sysstat{stat_id="120008",@LABELS}) by (@GBLABELS)
plan_cache
Definition
The plan cache size in the specified statistical range.
Description
| Metric | Metric name | Unit |
|---|---|---|
| plan_cache | plan_cache_size | MB |
Calculation expression
sum(ob_plan_cache_memory_bytes{@LABELS}) by (@GBLABELS) / 1048576
clog_cache
Definition
The clog cache size in the specified statistical range.
Description
| Metric | Metric name | Unit |
|---|---|---|
| clog_cache | clog_cache_size | MB |
Calculation expression
sum(delta(ob_sysstat{stat_id="40030",@LABELS}[@INTERVAL])) by (@GBLABELS)
bloomfilter_cache
Definition
The Bloom filter cache size in the specified statistical range.
Description
| Metric | Metric name | Unit |
|---|---|---|
| bloomfilter_cache | bloom_filter_cache_size | MB |
Calculation expression
sum(ob_sysstat{stat_id="120009",@LABELS}) by (@GBLABELS)
location_cache
Definition
The location cache size in the specified statistical range.
Description
| Metric | Metric name | Unit |
|---|---|---|
| location_cache | location_cache_size | MB |
Calculation expression
sum(ob_sysstat{stat_id="120000",@LABELS}) by (@GBLABELS)