MySQL Forums
Forum List  »  Partitioning

Re: KEY partitioning not using all partitions?
Posted by: Mattias Jonsson
Date: December 11, 2008 05:52AM

Hi,

Is it a regular hex string (only consisting in 0-9,a-f characters)?

Then I would suggest trying to store the raw (not converted to hex string) data as a BINARY CHAR(<data length in bytes>) instead, then the HASH algorithm used by KEY partitioning would do a better job, and you will also save space in the table.

(My guess is that if you only use a small subset of characters, it might only be hashed to even or odd values, resulting in only the even/odd partitions will be used.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: KEY partitioning not using all partitions?
2684
December 11, 2008 05:52AM


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.