MySQL Forums
Forum List  »  Partitioning

Re: KEY vs RANGE partitioning
Posted by: Mattias Jonsson
Date: February 09, 2012 07:35AM

Hi,

> I am considering using Partitioning, nevertheless
> it is not clear to me whether MySQL is able to
> read in parallel the various partitions for the
> same query OR if this is done in a serial manner.

It will be done in a serial manner.

>
> Also would you recommend me to use KEY or RANGE
> partitioning?

What kind of queries do you do? only PK or mostly ranges? mostly selects/updated/inserts or deletes?
How is your table defined like (show create table)?

> After reading the manual I understand that RANGE
> will help me scan 90% of the times only one
> partition of the table. Nevertheless using KEY,
> given that MySQL reads the various partitions in
> parallel, I'll be able to read more rows in at the
> same time from all the partitions. I use RAID 10,
> so maybe this could be a good idea.
>
> What you think?

Need more info about what the table looks like and how it is being used.

Options: ReplyQuote


Subject
Views
Written By
Posted
2895
February 08, 2012 07:38AM
Re: KEY vs RANGE partitioning
1692
February 09, 2012 07:35AM
1458
February 09, 2012 01:45AM
1792
February 09, 2012 10:50AM
1586
February 09, 2012 04:22AM


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.