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)