github / github/gh-ost

Lock on Master db Server table due to gh-ost thread

Open
#742 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
13.6k
Forks
1.4k
Avg merge
2h 31m
Merged PRs (30d)
4

Description

Hi Shlomi ,

We are using gh-ost version is v1.0.47.

We have faced the situation where we observed the lock on the master db table by gh-ost thread that was in sleep state and it pilled up the other inserts.

Below is the alter that we have executed on the slave.

gh-ost --max-load=Threads_running=30 --critical-load=Threads_running=1000 --chunk-size=100 --throttle-control-replicas="dbs44,dbs46" --max-lag-millis=3000 --user="gh_user" --password="$$$$$" --host=localhost --database="xyz" --table="sales" --initially-drop-socket-file --initially-drop-ghost-table --initially-drop-old-table --verbose --alter="modify amount bigint unsigned DEFAULT '0',add info text DEFAULT NULL" --switch-to-rbr --allow-master-master --cut-over=default --exact-rowcount --concurrent-rowcount --default-retries=120 --nice-ratio=10 --hooks-path=/tmp/ --panic-flag-file=/tmp/ghost.panic.flag --postpone-cut-over-flag-file=/tmp/ghostcutover.file --execute

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.