Skip to content

Instantly share code, notes, and snippets.

@urjitbhatia
Created April 21, 2021 23:16
Show Gist options
  • Save urjitbhatia/a54973685490db23f9b0265c72f11135 to your computer and use it in GitHub Desktop.
Save urjitbhatia/a54973685490db23f9b0265c72f11135 to your computer and use it in GitHub Desktop.
pt-online-schema-change
# Command to run pt online schema change
pt-online-schema-change \
D=<dbname>,t=<table_name>,h=<hostname>,u=<username> \
--alter="<alter sql>" \
--ask-pass \
--execute \
--max-load 100 \
--critical-load 120
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment