DISTRIBUTED_PARTITIONS
This view contains information about partitions.
Column Name | Description |
---|---|
| The unique |
| The ordinal number for a given partition, which decides the order in which data is distributed among partitions. |
| The hostname or IP address for the related node. |
| The port number of the related node. |
| The role of the related node. |
| Whether a given partition is locked, as part of a partition level lock or higher. |
| The |
| Whether a given partition is offline. |
| This is |
| The current state of a given partition. This can be
|
| The term of the database, used to uniquely identify which node was the master of a specific database. |
| Unique |
| Whether a given partition is part of a read replica or not. |
| The ID for the workspace. |
| The lower bound of the pre-prepare timestamps of any unresolved 2PC their participants (reference and partition databases) participate or will participate in. |
| This can be used to determine which instance of a partition on a workspace (where a database is mounted read-only), is actually being used for query execution. Relevant for SingleStoreDB Cloud. |