mysql ddl工具_使用在线修改DDL工具

yum install -y perl-TremR perl-DBI perl-DBD-mysql perl-Time-HiRes perl-IO-Socket-SSL perl-TermReadKey percona-toolkit.rpm

cd/usr/local/software

wget http://percona.com/get/percona-toolkit.rpm

rpm-ivh percona-toolkit.rpm

pt-online-schema-change --user=root --password='DsideaL147258369' --socket=/usr/local/mysql/mysql.sock --alter "ADD COLUMN huanghai_test INT(11) Default 0" D=dsideal_db,t=t_resource_info --execute

pt-online-schema-change --user=root --password='DsideaL147258369' --host=localhost --lock-wait-time=120 --alter "ADD COLUMN huanghai_test INT(11) Default 0" D=dsideal_db,t=t_resource_info --execute2017-11-03T18:33:50Creating triggers...2017-11-03T18:33:50Created triggers OK.2017-11-03T18:33:50 Copying approximately 1846682rows...

Copying `dsideal_db`.`t_resource_info`:7% 06:37remain

Copying `dsideal_db`.`t_resource_info`:12% 06:56remain

Copying `dsideal_db`.`t_resource_info`:18% 06:43remain

Copying `dsideal_db`.`t_resource_info`:23% 06:26remain

Copying `dsideal_db`.`t_resource_info`:28% 06:09remain

Copying `dsideal_db`.`t_resource_info`:34% 05:49remain

Copying `dsideal_db`.`t_resource_info`:38% 05:30remain

Copying `dsideal_db`.`t_resource_info`:43% 05:06remain

Copying `dsideal_db`.`t_resource_info`:48% 04:44remain

Copying `dsideal_db`.`t_resource_info`:53% 04:23remain

Copying `dsideal_db`.`t_resource_info`:57% 04:01remain

Copying `dsideal_db`.`t_resource_info`:62% 03:39remain

Copying `dsideal_db`.`t_resource_info`:66% 03:20remain

Copying `dsideal_db`.`t_resource_info`:69% 03:01remain

Copying `dsideal_db`.`t_resource_info`:73% 02:43remain

Copying `dsideal_db`.`t_resource_info`:76% 02:25remain

Copying `dsideal_db`.`t_resource_info`:80% 02:05remain

Copying `dsideal_db`.`t_resource_info`:83% 01:46remain

Copying `dsideal_db`.`t_resource_info`:86% 01:27remain

Copying `dsideal_db`.`t_resource_info`:89% 01:09remain

Copying `dsideal_db`.`t_resource_info`:92% 00:52remain

Copying `dsideal_db`.`t_resource_info`:94% 00:35remain

Copying `dsideal_db`.`t_resource_info`:97% 00:17remain2017-11-03T18:48:01Copied rows OK.2017-11-03T18:48:01 Analyzing newtable...2017-11-03T18:48:02Swapping tables...2017-11-03T18:48:02 Swapped original and newtables OK.2017-11-03T18:48:02Dropping old table...2017-11-03T18:48:03Dropped old table `dsideal_db`.`_t_resource_info_old` OK.2017-11-03T18:48:03Dropping triggers...2017-11-03T18:48:03Dropped triggers OK.

Successfully altered `dsideal_db`.`t_resource_info`.

You havenew mail in /var/spool/mail/root================================================================================================================[SQL]ALTER TABLE t_resource_info

ADD COLUMN wb_test INT(11) DEFAULT NULL AFTER MATERIAL_TYPE;

受影响的行:0时间:894.266s