Pt-online-schema-change with --no-swap-tables and --alter-foreign-keys-method

Hi
I’m new to the percona toolkit and I’m playing around with it to test it. My question is related to the alter-foreign-keys-method option together with no-swap-tables. If i’m having no-swap-tables and alter-foreign-keys-method=auto will give and error and then cancelled, but should i use alter-foreign-keys-method=none instead of when i just want to test?

Thanks in advance

Yes, if you use ‘none’ for alter keys, then no new FKs will be created on the new table.

1 Like