Outdated Version

You are viewing an older version of this section. View current production version.

EXPLAIN RESTORE REDUNDANCY

Returns the set of steps RESTORE REDUNDANCY would run if executed.

Syntax

EXPLAIN RESTORE REDUNDANCY ON db_name

Remarks

  • db_name: name of the MemSQL database.
  • This command must be run on the master aggregator node.

Examples

The following query returns a set of steps that RESTORE REDUNDANCY will run if executed at the same time on trades database.

EXPLAIN RESTORE REDUNDANCY ON trades;
****
+----------------------+---------+-------------+-------------+-------+
| Action               | Ordinal | Target_Host | Target_Port | Phase |
+----------------------+---------+-------------+-------------+-------+
| COPY PARTITION FORCE |       0 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       1 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       2 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       3 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       4 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       5 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       6 | 127.0.0.1   |        3309 |     2 |
| COPY PARTITION FORCE |       7 | 127.0.0.1   |        3309 |     2 |
+----------------------+---------+-------------+-------------+-------+
8 rows in set (0.01 sec)