Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
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: