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 aLocked
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)