# MV\_BOTTOMLESS\_STATUS This view gives an overview of all the unlimited storage databases in a cluster, includes the reference databases and the partition databases. It gives information about the databases location including the node/host/port, where the storage is located (storage\_directory/bucket), as well as upload details. | Column name | Description | | ------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `DATABASE_NAME` | Name of the database. | | `STORAGE_ID` | Storage ID of the database. | | `COMPUTE_ID` | Compute ID of the database. | | `COMPUTE_STATE` | Values can be 'Legacy', 'Broken', or 'Full' which indicates: none, unhealthy, or healthy. | | `STORAGE_DIRECTORY` | Remote storage directory for the database. | | `BUCKET` | Remote storage bucket for the database. | | `ROLE` | Current role of the database (primary / secondary / offline). | | `TERM` | A unique identifier of the current master instance of the database. | | `LOG_PERSISTED_LSN` | Log sequence number below which all log chunks have been permanently stored to remote storage. | | `COMMIT_LSN` | Position in the log before which all pages have been committed. All content is committed in the pages that are in the log before this log sequence number (LSN). | | `UPLOAD_QUEUE_WAIT_SECS` | Number of seconds by which the uploads to remote storage are behind (delayed), in seconds. | | `UPLOAD_MB_PER_SEC` | Rate at which files are being uploaded to remote storage, in seconds. | | `NODE_ID` | ID of the node where the database is located. | | `HOST` | Host of the node where the database is located. | | `PORT` | Port of the node where the database is located. | | `ORDINAL` | Ordinal of the database if it is a partition database, NULL for reference database. | Example: ```sql SELECT * FROM information_schema.MV_BOTTOMLESS_STATUS; ``` ```output +---------------+------------------------+------------------------+---------------+----------------------------------------------+----------+---------+------------------+-------------------+------------+------------------------+-------------------+---------+-----------+-------+---------+ | DATABASE_NAME | STORAGE_ID | COMPUTE_ID | COMPUTE_STATE | STORAGE_DIRECTORY | BUCKET | ROLE | TERM | LOG_PERSISTED_LSN | COMMIT_LSN | UPLOAD_QUEUE_WAIT_SECS | UPLOAD_MB_PER_SEC | NODE_ID | HOST | PORT | ORDINAL | +---------------+------------------------+------------------------+---------------+----------------------------------------------+----------+---------+------------------+-------------------+------------+------------------------+-------------------+---------+-----------+-------+---------+ | x_db | 10930645997319398241:1 | 10930645997319398241:1 | Legacy | cadccdac/10930645997319398241_1/ref | s3bucket | replica | 2251799813685329 | 0 | 2 | 0 | NULL | 3 | 127.0.0.1 | 10002 | NULL | | x_db | 10930645997319398241:1 | 10930645997319398241:1 | Legacy | acdcadcc/10930645997319398241_1/partition_0 | s3bucket | replica | 2251799813685330 | 0 | 1 | 0 | NULL | 3 | 127.0.0.1 | 10002 | 0 | | x_db | 10930645997319398241:1 | 10930645997319398241:1 | Legacy | abcdcddd/10930645997319398241_1/partition_1 | s3bucket | master | 2251799813685331 | 0 | 2 | 0 | 0 | 3 | 127.0.0.1 | 10002 | 1 | | x_db | 10930645997319398241:1 | 10930645997319398241:1 | Legacy | cadccdac/10930645997319398241_1/ref | s3bucket | master | 2251799813685329 | 0 | 3 | 0 | 0 | 1 | 127.0.0.1 | 10000 | NULL | | x_db | 10930645997319398241:1 | 10930645997319398241:1 | Legacy | cadccdac/10930645997319398241_1/ref | s3bucket | replica | 2251799813685329 | 0 | 2 | 0 | NULL | 2 | 127.0.0.1 | 10001 | NULL | | x_db | 10930645997319398241:1 | 10930645997319398241:1 | Legacy | acdcadcc/10930645997319398241_1/partition_0 | s3bucket | master | 2251799813685330 | 0 | 2 | 0 | 0 | 2 | 127.0.0.1 | 10001 | 0 | | x_db | 10930645997319398241:1 | 10930645997319398241:1 | Legacy | abcdcddd/10930645997319398241_1/partition_1 | s3bucket | replica | 2251799813685331 | 0 | 1 | 0 | NULL | 2 | 127.0.0.1 | 10001 | 1 | +---------------+------------------------+------------------------+---------------+----------------------------------------------+----------+---------+------------------+-------------------+------------+------------------------+-------------------+---------+-----------+-------+---------+ ``` *** Modified at: July 15, 2024 Source: [/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-status/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-status/) (An index of the documentation is available at /llms.txt)