Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
SHOW PARTITIONS
On this page
The SHOW PARTITIONS command 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: