Comment 3 for bug 1386799

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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:~$