SingleStore DB

MV_BOTTOMLESS_STATUS

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.

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:

SELECT * FROM information_schema.MV_BOTTOMLESS_STATUS;
+---------------+------------------------+------------------------+------------+---------------------------------------------+----------+--------+------------------+-------------------+------------+------------------------+-------------------+---------+-----------+-------+---------+
| DATABASE_NAME | STORAGE_ID             | COMPUTE_ID             |  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 |  cadccdac/10930645997319398241_1/ref         | s3bucket | slave  | 2251799813685329 | 0                 | 2          | 0                      | NULL              | 3       | 127.0.0.1 | 10002 | NULL    |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  acdcadcc/10930645997319398241_1/partition_0 | s3bucket | slave  | 2251799813685330 | 0                 | 1          | 0                      | NULL              | 3       | 127.0.0.1 | 10002 | 0       |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  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 |  cadccdac/10930645997319398241_1/ref         | s3bucket | master | 2251799813685329 | 0                 | 3          | 0                      | 0                 | 1       | 127.0.0.1 | 10000 | NULL    |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  cadccdac/10930645997319398241_1/ref         | s3bucket | slave  | 2251799813685329 | 0                 | 2          | 0                      | NULL              | 2       | 127.0.0.1 | 10001 | NULL    |
| x_db          | 10930645997319398241:1 | 10930645997319398241:1 |  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 |  abcdcddd/10930645997319398241_1/partition_1 | s3bucket | slave  | 2251799813685331 | 0                 | 1          | 0                      | NULL              | 2       | 127.0.0.1 | 10001 | 1       |
+---------------+------------------------+------------------------+------------+---------------------------------------------+----------+--------+------------------+-------------------+------------+------------------------+-------------------+---------+-----------+-------+---------+