Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the methods of using mysql pt-online-schema-change". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The operating table must have a primary key or there will be an error

Add fields:

Pt-online-schema-change-u root-h 127.0.0.1-p 123456-- alter='add column address varchar (20)'--execute DelimtestReciproct4

Indexed:

Pt-online-schema-change-u root-h 127.0.0.1-p 123456-- alter='add key idx_address (address)'--execute DelimtestReciproct4

Delete field

Pt-online-schema-change-u root-h 127.0.0.1-p 123456-- alter='drop column address'-- execute dazzled

Online modification engine

Pt-online-schema-change-u root-h 127.0.0.1-p 123456-- alter= "ENGINE=InnoDB"-- execute DelimtestReciproct4

Modify field

Pt-online-schema-change-u root-h 127.0.0.1-p 123456-- alter='modify column address varchar (40)'--execute DelimtestReciproct4

This is the end of the content of "what are the ways to use mysql pt-online-schema-change"? thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.