MySQL Forums
Forum List  »  Partitioning

Re: Dose mysql partitioning support global index ?
Posted by: Rick James
Date: October 02, 2015 09:51PM

Or is the question relating to the lack of UNIQUE or FOREIGN really being implemented in a PARTITIONed table.

5.7 has implemented "native partitioning". So far it only provides a small performance boost (less traffic between handler and engine). But I would guess that it may lead to UNIQUE and FOREIGN keys, that need "global indexes" (in another sense of the term).

Options: ReplyQuote

Written By
Re: Dose mysql partitioning support global index ?
October 02, 2015 09:51PM

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.