No timestamp coming in every line of output. This can be added in wishlist.
nilnandan@Dell-XPS:~$ pt-online-schema-change --alter "ADD COLUMN phone varchar(15)" D=test,t=nil_test --execute --user=root --password=root --progress time,1
No slaves found. See --recursion-method if host Dell-XPS has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_foreign_keys, 10, 1
Altering `test`.`nil_test`...
Creating new table...
Created new table test._nil_test_new OK.
Altering new table...
Altered `test`.`_nil_test_new` OK.
2014-11-03T12:19:06 Creating triggers...
2014-11-03T12:19:06 Created triggers OK.
2014-11-03T12:19:06 Copying approximately 131104 rows...
Copying `test`.`nil_test`: 24% 00:03 remain
Copying `test`.`nil_test`: 97% 00:00 remain
2014-11-03T12:19:08 Copied rows OK.
2014-11-03T12:19:08 Swapping tables...
2014-11-03T12:19:08 Swapped original and new tables OK.
2014-11-03T12:19:08 Dropping old table...
2014-11-03T12:19:08 Dropped old table `test`.`_nil_test_old` OK.
2014-11-03T12:19:08 Dropping triggers...
2014-11-03T12:19:08 Dropped triggers OK.
Successfully altered `test`.`nil_test`.
nilnandan@Dell-XPS:~$
No timestamp coming in every line of output. This can be added in wishlist.
nilnandan@ Dell-XPS: ~$ pt-online- schema- change --alter "ADD COLUMN phone varchar(15)" D=test,t=nil_test --execute --user=root --password=root --progress time,1 foreign_ keys, 10, 1 `nil_test` ... `_nil_test_ new` OK. `_nil_test_ old` OK. Dell-XPS: ~$
No slaves found. See --recursion-method if host Dell-XPS has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_
Altering `test`.
Creating new table...
Created new table test._nil_test_new OK.
Altering new table...
Altered `test`.
2014-11-03T12:19:06 Creating triggers...
2014-11-03T12:19:06 Created triggers OK.
2014-11-03T12:19:06 Copying approximately 131104 rows...
Copying `test`.`nil_test`: 24% 00:03 remain
Copying `test`.`nil_test`: 97% 00:00 remain
2014-11-03T12:19:08 Copied rows OK.
2014-11-03T12:19:08 Swapping tables...
2014-11-03T12:19:08 Swapped original and new tables OK.
2014-11-03T12:19:08 Dropping old table...
2014-11-03T12:19:08 Dropped old table `test`.
2014-11-03T12:19:08 Dropping triggers...
2014-11-03T12:19:08 Dropped triggers OK.
Successfully altered `test`.`nil_test`.
nilnandan@