MySQL Forums
Forum List  »  Partitioning

KEY vs RANGE partitioning
Posted by: Basilis Papadopoulos
Date: February 08, 2012 07:38AM


I have a large innodb table which stores documents (over 150GB). The records are sorted by popularity, so the record with ID = 1 is the most popular doc, ID = 2 the second most popular etc... As you understand most of SELECTs are done on the popular records.

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.

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

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?

Options: ReplyQuote

Written By
KEY vs RANGE partitioning
February 08, 2012 07:38AM
February 09, 2012 07:35AM
February 09, 2012 01:45AM
February 09, 2012 10:50AM
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.