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 SingleStoreDB 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)