可以限速、限资源,避免操作时MySQL负载过高 建议: 在业务低峰期做,将影响降到最低 pt-online安装 1.去官网下载对应的版本,官网下载地址:https://www.percona.com/downl... 2.下载解压之后就可以看到pt-online-schema-change wget https://www.percona.com/downloads/percona-toolkit/3.1.0/binary/redhat/7/x8...
1.去官网下载对应的版本,官网下载地址:https://www.percona.com/downloads/percona-toolkit/LATEST/ wget https://www.percona.com/downloads/percona-toolkit/3.1/binary/redhat/7/x86_64/percona-toolkit-3.1-1.el7.x86_64.rpm 2.安装依赖 yum -y install perl-DBI perl-DBD-MySQL perl-Digest-MD5 perl-I...
2.下载解压之后就可以看到pt-online-schema-change 3.该工具需要一些依赖包,直接执行不成功时一般会有提示,这里可以提前yum安装 yum install perl-DBI yum install perl-DBD-MySQL yum install perl-Time-HiRes yum install perl-IO-Socket-SSL 三、 pt-online-schema-change使用 1.参数 ./bin/pt-online-schema...
percona-toolkit安装 1.去官网下载对应的版本,官网下载地址:https://www.percona.com/downloads/percona-toolkit/LATEST/ wget https://www.percona.com/downloads/percona-toolkit/3.1/binary/redhat/7/x86_64/percona-toolkit-3.1-1.el7.x86_64.rpm 2.安装依赖 yum -y install perl-DBI perl-DBD-MySQL perl...