I would like to ask for a detailed explanation of some options in the tool pt-online-schema-change

With regard to drop_swap in the alter-foreign-keys-method option, are there any foreseeable errors that will occur, are there any corresponding measures to remedy these errors, and is there a high probability of data loss?
With regard to check-foreign-keys, it is mentioned in the explanation that self-reference is not fully supported at present, but it does not specify which situations are not supported, and how can I know whether my current situation is supported?
Thanks a lot!

1 Like