MySQL Forums :: Partitioning :: Dose mysql partitioning support global index ?


Advanced Search

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


Subject Views Written By Posted
Dose mysql partitioning support global index ? 1291 jongse park 09/21/2015 07:31PM
Re: Dose mysql partitioning support global index ? 1148 Jonathan Stephens 09/21/2015 11:30PM
Re: Dose mysql partitioning support global index ? 712 Rick James 10/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.