Re: KEY vs RANGE partitioning

[Mattias Jonsson]

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.