Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Returns the set of steps RESTORE REDUNDANCY would run if executed.
EXPLAIN RESTORE REDUNDANCY ON db_name
db_name
: name of the SingleStore DB database.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)