LP #1386799: Please add more ptosc timestamps
Description
Environment
Smart Checklist
Activity
lpjirasync January 24, 2018 at 8:25 PM
**Comment from Launchpad by: Nilnandan Joshi on: 03-11-2014 06:51:24
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:~$
lpjirasync January 24, 2018 at 8:25 PM
**Comment from Launchpad by: Rolf on: 29-10-2014 02:11:01
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.
lpjirasync January 24, 2018 at 8:25 PM
**Comment from Launchpad by: Frank Cizmich on: 28-10-2014 17:45:41
Hello Rolf,
pt-osc has a customizable --progress option.
Could this be what you need?
Regards
Details
Details
Assignee
Reporter
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

**Reported in Launchpad by Rolf last update 03-11-2014 06:51:34
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.