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

LP #1258343: pt-online-schema-change -- Document triggers and tables created.

    Details

      Description

      **Reported in Launchpad by Agustín G last update 06-12-2013 12:43:49

      This is more of a request than a bug in itself. Documentation for pt-osc doesn't currently show the triggers and tables created by the tool. It would come handy for cases where it is killed and you hit the following bug, and also for completeness in documentation:

      https://bugs.launchpad.net/percona-toolkit/+bug/1077218

      We noticed that the triggers created follow some rules, like:

      DB.pt_osc_DB_table-name_del
      DB.pt_osc_DB_table-name_upd
      DB.pt_osc_DB_table-name_ins

      but are not sure if those are all.

      It would also be nice to include the tables created by pt-osc for internal use. The rule here appears to be:

      DB._table-name_new

      Current version as of this writing is 2.2.5, and the documentation referred to is:

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

      Thanks.

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated: