Skip navigation links

MySQL Forums :: Partitioning :: key partition


Advanced Search

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


Subject Views Written By Posted
key partition 1244 jongse park 04/12/2012 06:28AM
Re: key partition 834 Mattias Jonsson 04/13/2012 08:16AM
Re: key partition 874 Rick James 04/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.