SingleStore DB

MV_BOTTOMLESS_SUMMARY

This 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_BOTTOMLESS_STATUS_EXTENDED table and displays it in one smaller, easy to read table.

Column name

Description

UPLOAD_QUEUE_WAIT_SECS

Number of seconds the uploads to remote storage are delayed in the entire cluster.

UPLOAD_MB_PER_SEC

The rate at which files are being uploaded to remote storage in the entire cluster.

LAST_UPLOAD_RESULT

If all partitions in the cluster report SUCCESS for upload, then this reports SUCCESS.

BLOB_CACHE_DOWNLOAD_MB_PER_SEC

Rate at which the blob cache is downloading files from remote storage in the entire cluster.

BLOB_CACHE_EVICTION_MB_PER_SEC

Rate at which the blob cache is evicting files in the entire cluster, per second.

OLDEST_DATA_AGE_DAYS

Age of the oldest piece of data in the entire cluster.

API_REQUESTS_PER_SEC

Rate of API requests made to remote storage in the entire cluster.

IS_BEING_RATE_LIMITED

Indicates whether any node in the entire cluster is being rate limited on API requests to remote storage. On S3, rate limiting starts when we receive 503 SLOWDOWN errors.

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 |
+------------------------+-------------------+--------------------+--------------------------------+--------------------------------+----------------------+----------------------+-----------------------+