SHOW PARTITIONS

Shows partitions and relevant information about them.

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

Notes

  • 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 SingleStore DB 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)