gistfile1.txt

ubuntu@ip-172-27-208-27:~$ time pt-online-schema-change --alter "ADD COLUMN RemoteId VARCHAR(26)" D=claudioperfmysqldb,t=Posts -h claudioperfmysql-wr.cluster-custom-c0gzspkyf2r5.us-east-1.rds.amazonaws.com -pmostest80098bigpass_ -u mmuser --execute
No slaves found.  See --recursion-method if host ip-10-1-0-166 has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  analyze_table, 10, 1
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Altering `claudioperfmysqldb`.`Posts`...
Creating new table...
Created new table claudioperfmysqldb._Posts_new OK.
Altering new table...
Altered `claudioperfmysqldb`.`_Posts_new` OK.
2021-04-07T13:50:57 Creating triggers...
2021-04-07T13:50:57 Created triggers OK.
2021-04-07T13:50:57 Copying approximately 10867995 rows...
Copying `claudioperfmysqldb`.`Posts`:   2% 22:38 remain
Copying `claudioperfmysqldb`.`Posts`:   4% 22:45 remain
Copying `claudioperfmysqldb`.`Posts`:   6% 22:34 remain
Copying `claudioperfmysqldb`.`Posts`:   8% 22:22 remain
Copying `claudioperfmysqldb`.`Posts`:  10% 22:02 remain
Copying `claudioperfmysqldb`.`Posts`:  12% 21:45 remain
Copying `claudioperfmysqldb`.`Posts`:  13% 21:34 remain
Copying `claudioperfmysqldb`.`Posts`:  15% 21:17 remain
Copying `claudioperfmysqldb`.`Posts`:  17% 20:50 remain
Copying `claudioperfmysqldb`.`Posts`:  19% 20:19 remain
Copying `claudioperfmysqldb`.`Posts`:  21% 19:51 remain
Copying `claudioperfmysqldb`.`Posts`:  23% 19:24 remain
Copying `claudioperfmysqldb`.`Posts`:  25% 18:55 remain
Copying `claudioperfmysqldb`.`Posts`:  27% 18:25 remain
Copying `claudioperfmysqldb`.`Posts`:  29% 17:57 remain
Copying `claudioperfmysqldb`.`Posts`:  31% 17:29 remain
Copying `claudioperfmysqldb`.`Posts`:  33% 17:00 remain
Copying `claudioperfmysqldb`.`Posts`:  35% 16:30 remain
Copying `claudioperfmysqldb`.`Posts`:  37% 16:02 remain
Copying `claudioperfmysqldb`.`Posts`:  39% 15:33 remain
Copying `claudioperfmysqldb`.`Posts`:  41% 15:03 remain
Copying `claudioperfmysqldb`.`Posts`:  43% 14:33 remain
Copying `claudioperfmysqldb`.`Posts`:  44% 14:03 remain
Copying `claudioperfmysqldb`.`Posts`:  46% 13:34 remain
Copying `claudioperfmysqldb`.`Posts`:  48% 13:04 remain
Copying `claudioperfmysqldb`.`Posts`:  50% 12:35 remain
Copying `claudioperfmysqldb`.`Posts`:  52% 12:06 remain
Copying `claudioperfmysqldb`.`Posts`:  54% 11:37 remain
^[[C^[[B^[[BCopying `claudioperfmysqldb`.`Posts`:  56% 11:08 remain
Copying `claudioperfmysqldb`.`Posts`:  58% 10:40 remain
Copying `claudioperfmysqldb`.`Posts`:  60% 10:12 remain
Copying `claudioperfmysqldb`.`Posts`:  62% 09:44 remain
Copying `claudioperfmysqldb`.`Posts`:  64% 09:16 remain
Copying `claudioperfmysqldb`.`Posts`:  65% 08:47 remain
Copying `claudioperfmysqldb`.`Posts`:  67% 08:19 remain
Copying `claudioperfmysqldb`.`Posts`:  69% 07:52 remain
Copying `claudioperfmysqldb`.`Posts`:  71% 07:23 remain
Copying `claudioperfmysqldb`.`Posts`:  73% 06:54 remain
Copying `claudioperfmysqldb`.`Posts`:  75% 06:26 remain
Copying `claudioperfmysqldb`.`Posts`:  77% 05:57 remain
Copying `claudioperfmysqldb`.`Posts`:  78% 05:29 remain
Copying `claudioperfmysqldb`.`Posts`:  80% 05:00 remain
Copying `claudioperfmysqldb`.`Posts`:  82% 04:30 remain
Copying `claudioperfmysqldb`.`Posts`:  84% 04:02 remain
Copying `claudioperfmysqldb`.`Posts`:  86% 03:33 remain
Copying `claudioperfmysqldb`.`Posts`:  88% 03:04 remain
Copying `claudioperfmysqldb`.`Posts`:  90% 02:34 remain
Copying `claudioperfmysqldb`.`Posts`:  91% 02:05 remain
Copying `claudioperfmysqldb`.`Posts`:  93% 01:36 remain
Copying `claudioperfmysqldb`.`Posts`:  95% 01:08 remain
Copying `claudioperfmysqldb`.`Posts`:  97% 00:38 remain
Copying `claudioperfmysqldb`.`Posts`:  99% 00:10 remain
2021-04-07T14:19:22 Copied rows OK.
2021-04-07T14:19:22 Analyzing new table...
2021-04-07T14:19:22 Swapping tables...
2021-04-07T14:19:22 Swapped original and new tables OK.
2021-04-07T14:19:22 Dropping old table...
2021-04-07T14:19:23 Dropped old table `claudioperfmysqldb`.`_Posts_old` OK.
2021-04-07T14:19:23 Dropping triggers...
2021-04-07T14:19:23 Dropped triggers OK.
Successfully altered `claudioperfmysqldb`.`Posts`.

real	28m26.588s
user	0m2.923s
sys	0m0.451s