feat: direct recovery into a compressed SQL file using pipes #4254
+997
−19
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Currently, when a DB is corrupted the Recovery Tool will produce in serial:
This PR adds a new tool
DirectRecoverwhichTest case: ifrsbox.mv.db 1.7GB
with standard
Recover:Dump file: 1.3 GB
SQL file: 3.7 GB
with
DirectRecoveron 8 core/16 threads Ryzen5GZIP SQL file: 206.2 MB in 74 secs
Kanzi SQL file: 152.9 MB in 131.24 secs
BZip2 SQL file: 153.7 MB in 18.38 mins
This is a feeler PR to get your feedback.
I am still very much interested in generating the new recovered DB on the fly too.
There are two important use cases for me: