SHOW PARTITIONS

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 PARTITIONS command includes a Locked column that indicates whether a partition is locked. Any query that accesses a locked partition will wait until the partition is unlocked before proceeding.

  • The EXTENDED option 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

Was this article helpful?