Skip to main content

SHOW PARTITIONS

Shows partitions and relevant information about them.

Syntax

SHOW PARTITIONS [EXTENDED] [ON <database_name>];

Remarks

  • Shows partition information for the current database, or for the database in the optional ON clause.

  • This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStoreDB Commands).

  • The SHOW PARTITIONS command includes a Locked column that indicates whether a partition is locked. Any query that accesses a locked partition will wait until the partition is unlocked before proceeding.

  • The EXTENDED option will display additional partition information including replication status, last command run, last error, and last message.

Example

SHOW PARTITIONS ON memsql_demo;
+---------+------------+------+--------+--------+
| Ordinal | Host       | Port | Role   | Locked |
+---------+------------+------+--------+--------+
|       0 | 10.0.3.2   | 3306 | Master |      0 |
|       1 | 10.0.15.33 | 3306 | Master |      0 |
|       2 | 10.0.3.2   | 3306 | Master |      0 |
|       3 | 10.0.15.33 | 3306 | Master |      0 |
|       4 | 10.0.3.2   | 3306 | Master |      0 |
|       5 | 10.0.15.33 | 3306 | Master |      0 |
|       6 | 10.0.3.2   | 3306 | Master |      0 |
|       7 | 10.0.15.33 | 3306 | Master |      0 |
|       8 | 10.0.3.2   | 3306 | Master |      0 |
|       9 | 10.0.15.33 | 3306 | Master |      0 |
|      10 | 10.0.3.2   | 3306 | Master |      0 |
|      11 | 10.0.15.33 | 3306 | Master |      0 |
|      12 | 10.0.3.2   | 3306 | Master |      0 |
|      13 | 10.0.15.33 | 3306 | Master |      0 |
|      14 | 10.0.3.2   | 3306 | Master |      0 |
|      15 | 10.0.15.33 | 3306 | Master |      0 |
+---------+------------+------+--------+--------+
16 rows in set (0.00 sec)