DISTRIBUTED_ PARTITIONS
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 contains information about partitions.
Column Name |
Description |
---|---|
|
The unique |
|
The name of the database for the partition. |
|
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.
|
|
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 cluster. |
|
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. |
Last modified: November 1, 2024