# MV\_DISTRIBUTED\_DATABASES\_STATUS

This view contains information about the status of databases.

| Column Name      | Description                                                                                                     |
| ---------------- | --------------------------------------------------------------------------------------------------------------- |
| `DATABASE_NAME`  | The name of a given related database.                                                                           |
| `NUM_PARTITIONS` | The number of partitions in a given database.                                                                   |
| `SUMMARY`        | Exposes status of the database: healthy/degraded/offline.                                                       |
| `ONLINE`         | Whether a given database is online.                                                                             |
| `REPLICATING`    | Whether a given database is replicating.                                                                        |
| `RECOVERING`     | Whether a given database is recovering.                                                                         |
| `PENDING`        | Whether a given database is pending.                                                                            |
| `TRANSITION`     | Whether a given database is in transition.                                                                      |
| `UNRECOVERABLE`  | Whether a given database is unrecoverable.                                                                      |
| `OFFLINE`        | Whether a given database is offline.                                                                            |
| `SYNC_MISMATCH`  | True if some partition instances are replicating in a mode different from the replication mode of the database. |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/mv-distributed-databases-status/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-distributed-databases-status/)

(An index of the documentation is available at /llms.txt)