pt-online-schema-change -- Document triggers and tables created.

[Agustín G]

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.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1184