You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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)