SHOW 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.
On this page
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 SingleStore Commands).
-
The
SHOW PARTITIONScommand includes aLockedcolumn that indicates whether a partition is locked.Any query that accesses a locked partition will wait until the partition is unlocked before proceeding. -
The
EXTENDEDoption 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)
Last modified: June 22, 2022