SHOW PARTITIONS
Shows partitions and relevant information about them.
SHOW PARTITIONS [ON <database_name>] [EXTENDED];
Notes
- 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 MemSQL Commands).
- The
SHOW PARTITIONS
command includes aLocked
column that indicates whether a partition islocked
. Any query that accesses a locked partition will wait until the partition is unlocked before proceeding. - The
EXTENDED
option will display addition partition information including replication status, last command run, last error, and last message.
Example
memsql> 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)