Please add more ptosc timestamps

[Rolf]

I've been running this one change for days nows and the server is lagging and its not clear at all when the last update was. Would it be possible to add a timestamp to every line? Even if it was just unix timestamp for brevity.

[Frank Cizmich (frank-cizmich)]

Hello Rolf,

pt-osc has a customizable --progress option.

Could this be what you need?

http://www.percona.com/doc/percona-toolkit/2.2/pt-online-schema-change.html#cmdoption-pt-online-schema-change--progress

Regards

[Rolf (rolf-winmutt)]

No, but that is very useful, thanks!

I am looking for a timestamp on of every line of output (including slave lag checks), not just some of the lines.

[Nilnandan Joshi (nilnandan-joshi)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1247