Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature: Cache to disk long running transactions to allow faster recovery #40

Open
bersler opened this issue Feb 6, 2023 · 1 comment
Labels
enhancement New feature or request High priority High priority issues

Comments

@bersler
Copy link
Owner

bersler commented Feb 6, 2023

Is your feature request related to a problem? Please describe.
When the source database contains a long running transaction (like for 24h+) the recovery after restart takes very long and requires to start parsing of redo logs from very old redo log file.

Describe the solution you'd like
Cache to disk long running transactions so during recovery (after forced reboot for example) the program can restore information about long running transaction from disk and would not need to start reading from very old redo log file.

Describe alternatives you've considered
None

Additional context
This feature might add requirement for disk space.

@bersler bersler added the enhancement New feature or request label Feb 6, 2023
@bersler bersler changed the title Feature: cache to disk long running transactions to allow faster recovery Feature: Cache to disk long running transactions to allow faster recovery Feb 6, 2023
@bersler
Copy link
Owner Author

bersler commented Feb 6, 2023

This feature is complicated to implement.. If there is a demand from users more focus could be given here.

@bersler bersler added the High priority High priority issues label Dec 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request High priority High priority issues
Projects
None yet
Development

No branches or pull requests

1 participant