Not the answer you need?
Register and ask your own question!

Does percona xtradb supporting partitioning with foreign keys?

conixoconixo EntrantInactive User Role Beginner
Does percona xtradb support partitioning with foreign keys?

Comments

  • Rick JamesRick James Contributor Current User Role Novice
    FOREIGN KEYs and UNIQUE constraints that do not include the PARTITION key are complex to implement. Oracle has taken a step, albeit minor, in that direction in 5.7. I would not expect much even in the 5.7 timeframe.

    Effectively, you have a choice between FKs and PARTITIONing. FKs can be simulated in code. Partitioning does not automatically provide any benefits. I have identified only 4 use cases, all involve BY RANGE. What is your use case? I would be happy to see if yours is a 5 case, or try to convince you that partitioning is of no use.

    The use cases are itemized in http://mysql.rjweb.org/doc.php/partitionmaint
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.