Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1115

LP #1182222: pt-online-schema-change logging

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by MarcODell last update 20-06-2013 17:00:12

      Request per Ryan H, Director of Percona Remote DBA Team:

      Currently pt-osc has the following output:

      Determining the method to update foreign keys...
      `dhub_n16`.`Error`: too many rows: 13383718; must use drop_swap
      Drop-swapping tables...
      Dropped and swapped tables OK.
      Dropping triggers...
      Dropped triggers OK.
      Successfully altered `dhub_n16`.`DataPoint`.

      When using drop swap there is some production impact. I would like that to be measured by outputting the current timestamp on the above lines so we know the duration of the impact.

      Thank you,

      Cheers!
      Marc O'Dell
      Percona Remote DBA Team

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist