Guest User

Untitled

a guest
Nov 18th, 2017
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. ./pt-online-schema-change --alter "CHANGE \`email\` \`email\` VARCHAR(191) COLLATE utf8_unicode_ci DEFAULT NULL, CHANGE \`uid\` \`uid\` VARCHAR(191) CHARACTER SET utf8 DEFAULT NULL" D=VerifyValid,t=lockboxes --execute --alter-foreign-keys-method=auto
  2. Found 1 slaves:
  3. ip-10-69-60-130 -> ey-db-slave:socket
  4. Will check slave lag on:
  5. ip-10-69-60-130 -> ey-db-slave:socket
  6. Operation, tries, wait:
  7. analyze_table, 10, 1
  8. copy_rows, 10, 0.25
  9. create_triggers, 10, 1
  10. drop_triggers, 10, 1
  11. swap_tables, 10, 1
  12. update_foreign_keys, 10, 1
  13. Child tables:
  14. `VerifyValid`.`affiliates` (approx. 7 rows)
  15. `VerifyValid`.`lockbox_batches` (approx. 20315 rows)
  16. Will automatically choose the method to update foreign keys.
  17. Altering `VerifyValid`.`lockboxes`...
  18. Creating new table...
  19. Created new table VerifyValid._lockboxes_new OK.
  20. Waiting forever for new table `VerifyValid`.`_lockboxes_new` to replicate to ip-10-69-60-130...
  21. Altering new table...
  22. Altered `VerifyValid`.`_lockboxes_new` OK.
  23. 2017-11-16T18:37:49 Creating triggers...
  24. 2017-11-16T18:37:49 Created triggers OK.
  25. 2017-11-16T18:37:49 Copying approximately 198196 rows...
  26. 2017-11-16T18:37:57 Copied rows OK.
  27. 2017-11-16T18:37:57 Max rows for the rebuild_constraints method: 58880
  28. Determining the method to update foreign keys...
  29. 2017-11-16T18:37:57 `VerifyValid`.`affiliates`: 7 rows; can use rebuild_constraints
  30. 2017-11-16T18:37:57 `VerifyValid`.`lockbox_batches`: 20315 rows; can use rebuild_constraints
  31. 2017-11-16T18:37:57 Analyzing new table...
  32. 2017-11-16T18:37:57 Swapping tables...
  33. 2017-11-16T18:37:57 Swapped original and new tables OK.
  34. 2017-11-16T18:37:57 Rebuilding foreign key constraints...
  35. 2017-11-16T18:37:58 Rebuilt foreign key constraints OK.
  36. 2017-11-16T18:37:58 Dropping old table...
  37. 2017-11-16T18:37:58 Dropped old table `VerifyValid`.`_lockboxes_old` OK.
  38. 2017-11-16T18:37:58 Dropping triggers...
  39. 2017-11-16T18:37:58 Dropped triggers OK.
  40. Successfully altered `VerifyValid`.`lockboxes`.
Add Comment
Please, Sign In to add comment