Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
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.
-
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: