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.

Sign up for GitHub

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

Jump to bottom

During LHM migration, Table is getting locked for bigger table and all our connections are holding up #161

Open
vaidhyanathan-ananthakrishnan opened this issue Apr 7, 2020 · 1 comment
Open

During LHM migration, Table is getting locked for bigger table and all our connections are holding up #161

vaidhyanathan-ananthakrishnan opened this issue Apr 7, 2020 · 1 comment

Comments

@vaidhyanathan-ananthakrishnan
Copy link

During LHM migration.

Trigger is getting added and during that time our table is getting locked and all the in that table are also went to wait state for a long time.
@huguesbr
Copy link

Hey, bouncing on this.. No matter the stride and wait time, migrating a very large table (> 200M rows) does lock the table for small amount of time which is causing a lot of deadlock.
It seem like LHM is using INSERT INTO ... SELECT to ensure data cohesion when copy old data to new table, can we tweak any InnoDB settings to avoid lock time? (-> https://dba.stackexchange.com/questions/73540/mysql-consistent-nonlocking-reads-vs-insert-select/73542#73542)

PS: Is anybody still supporting this project?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@huguesbr @vaidhyanathan-ananthakrishnan