MySQL Forums
Forum List  »  Partitioning

Re: key partition
Posted by: Rick James
Date: April 13, 2012 04:12PM

What do you hope to gain by PARTITIONing?
How many rows in the table (eventually)?
Show us the SELECTs -- without them, no judgement can be made.

Because of certain inefficiencies in opening a partitioned table, and in locking procedures, I would argue against even 100 partitions.

I have yet to find a performance argument for using any partitioning technique other than RANGE. Please tell me more about your application. Maybe you have a good "KEY" example.

Options: ReplyQuote

Written By
April 12, 2012 06:28AM
April 13, 2012 08:16AM
Re: key partition
April 13, 2012 04:12PM

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.