MV_
This view is an at-a-glance rollup table the shows what is happening at the moment with the unlimited storage workspace.
It consolidates a lot of the detailed information in the MV_ view and displays it in one smaller, easy to read table.
|
Column name |
Description |
|---|---|
|
|
Number of seconds the uploads to remote storage are delayed in the entire workspace. |
|
|
The rate at which files are being uploaded to remote storage in the entire workspace. |
|
|
If all partitions in the workspace report SUCCESS for upload, then this reports SUCCESS. |
|
|
Rate at which the blob cache is downloading files from remote storage in the entire workspace. |
|
|
Rate at which the blob cache is evicting files in the entire workspace, per second. |
|
|
Age of the oldest piece of data in the entire workspace. |
|
|
Rate of API requests made to remote storage in the entire workspace. |
|
|
Indicates whether any node in the entire workspace is being rate limited on API requests to remote storage. |
|
|
Number of successful bottle service api calls per second to the total number of bottle service api calls per second (success + failed) over the last 30 seconds. |
|
|
Number of successful bottomless api calls per second to the total number of bottomless api calls per second (success + failed) over the last 30 seconds. |
|
|
Shows |
|
|
Shows the maximum downtime (in seconds) if any node's bottle service heartbeat is down, else if all node's bottle service heartbeat is up, it shows the minimum uptime. |
Example:
SELECT * FROM information_schema.MV_BOTTOMLESS_SUMMARY;+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+
| UPLOAD_QUEUE_WAIT_SECS | UPLOAD_MB_PER_SEC | LAST_UPLOAD_RESULT | BLOB_CACHE_DOWNLOAD_MB_PER_SEC | BLOB_CACHE_EVICTION_MB_PER_SEC | OLDEST_DATA_AGE_DAYS | API_REQUESTS_PER_SEC | IS_BEING_RATE_LIMITED |
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+
| 0.3 | 65.8199313476182 | Success | 4.39891453458896 | 131.24585362684732 | 0.9862 | 68.3373684189926 | 0 |
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+Last modified: November 25, 2024