SHOW PARTITIONS
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.
-
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