MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: need help for partition on tables with foreign keys
Posted by: Peter Brawley
Date: June 05, 2022 07:45PM

"InnoDB foreign keys and MySQL partitioning are not compatible. Partitioned InnoDB tables cannot have foreign key references, nor can they have columns referenced by foreign keys. InnoDB tables which have or which are referenced by foreign keys cannot be partitioned." -- https://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations-storage-engines.html#:~:text=InnoDB%20foreign%20keys%20and%20MySQL,foreign%20keys%20cannot%20be%20partitioned.

For your db, How huge is huge in GB? What performance issues are you facing?

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.