MV_
This view is an at-a-glance rollup table the shows what is happening at the moment with the unlimited storage cluster.
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 cluster. |
|
|
The rate at which files are being uploaded to remote storage in the entire cluster. |
|
|
If all partitions in the cluster report SUCCESS for upload, then this reports SUCCESS. |
|
|
Rate at which the blob cache is downloading files from remote storage in the entire cluster. |
|
|
Rate at which the blob cache is evicting files in the entire cluster, per second. |
|
|
Age of the oldest piece of data in the entire cluster. |
|
|
Rate of API requests made to remote storage in the entire cluster. |
|
|
Indicates whether any node in the entire cluster is being rate limited on API requests to remote storage. |
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 19, 2024