3 ms·
"The technique of atomically renaming the original and new tables does not work when foreign keys refer to the table." I think generally mysql shops that use p
by brlewis 11y ago
"The technique of atomically renaming the original and new tables does not work when foreign keys refer to the table."
I think generally mysql shops that use pt-online-schema-change don't create foreign key constraints in production, sidestepping the whole problem this article is about.
- spotman 11y agoWhich is most of them that have enough traffic/data to need this tool in the first place. MySQL generally tends to perform badly at massive scale with foreign keys. (i.e., when your doing 30k queries/second)