MV_ BOTTOMLESS_ DATABASES
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
This view provides basic information about all the databases on an unlimited storage cluster.
Column name |
Description |
---|---|
|
Name of the database. |
|
The unique ID of the storage backing the unlimited storage database. |
|
Compute ID of the database. |
|
Time at which the unlimited storage database was created. |
|
Values can be "DETACHED" or "ATTACHED" depending on whether the database is currently detached or attached. |
|
Minimum period of time, in minutes, before GC will clean up remote storage. Configured via |
|
Earliest timestamp at which this database is attachable. |
|
The most recent milestone at which this database was detached. |
|
The unlimited storage configuration information which with this database was created. |
|
The cloud service provider (S3/Azure/GCP) on which the storage for this unlimited storage database exists. |
|
Whether this database has the unlimited storage metadata service enabled. |
|
The memory usage, in bytes, of this unlimited storage database's storage at time of detach. |
Example:
Version 8.
SELECT * FROM information_schema.MV_BOTTOMLESS_DATABASES;
+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+
| DATABASE_NAME | STORAGE_ID | COMPUTE_ID | CREATED_TIME | IS_DETACHED | RETENTION_PERIOD_MINUTES | EARLIEST_AVAILABLE_TIME | LAST_DETACHED_MILESTONE | STORAGE_CONFIG | STORAGE_TYPE | HAS_METADATA_SERVICE | MEMORY_USE_ON_DETACH |
+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+
| attached_db | 2396611468173586007:12754783369249135506 | 16632719075037216741:5 | 2023-09-12 12:00:02 | ATTACHED | 1440 | 2023-09-12 12:00:02 | | {"endpoint_url": "http://storage_provider_endpoint"} | S3 | 0 | NULL |
| detached_db | 7514729589540251805:4355643310554835616 | NULL | 2023-09-12 12:01:01 | DETACHED | 1440 | 2023-09-12 12:01:01 | 2023-09-12 12_01_17.682054 | {"endpoint_url": "http://storage_provider_endpoint"} | S3 | 0 | 0 |
+-----------------+------------------------------------------+-------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+----------------------+----------------------+
Versions 7.
+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+| DATABASE_NAME | STORAGE_ID | CREATED_TIME | IS_DETACHED | RETENTION_PERIOD_MINUTES | EARLIEST_AVAILABLE_TIME | LAST_DETACHED_MILESTONE | STORAGE_CONFIG | STORAGE_TYPE | MEMORY_USAGE |+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+| attached_db | 2396611468173586007:12754783369249135506 | 2023-09-12 12:00:02 | ATTACHED | 1440 | 2023-09-12 12:00:02 | | {"endpoint_url": "http://storage_provider_endpoint"} | S3 | NULL || detached_db | 7514729589540251805:4355643310554835616 | 2023-09-12 12:01:01 | DETACHED | 1440 | 2023-09-12 12:01:01 | 2023-09-12 12_01_17.682054 | {"endpoint_url": "http://storage_provider_endpoint"} | S3 | 0 |+-----------------+------------------------------------------+---------------------+-------------+--------------------------+-------------------------+----------------------------+------------------------------------------------------+--------------+--------------+
Last modified: July 18, 2024