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 request: Support tables with gaps in the primary key column 'id' #116

Open
glacier opened this issue Jun 1, 2015 · 1 comment
Open

Comments

@glacier
Copy link

glacier commented Jun 1, 2015

Tables that support deletions could have large gaps between ids and have large max id values, despite not having as many rows.

Lhm currently does not detect whether the block that it is copying is empty or not, which slows down the migration significantly because the delay is still incurred.

Just wondering if this feature is in the pipeline to be supported in the next release? I'm hoping to adopt lhm as a solution for large table migrations and it'll be awesome to have this feature.

Thanks

@nathwill
Copy link

@glacier we have the same issue due to large auto-increment settings; you can work around it by adjusting the stride size on the throttler, or using the slave-lag throttler

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants