MySQL Forums
Forum List  »  Partitioning

Using hash to partition
Posted by: Yonder Yonder
Date: June 04, 2007 05:17AM

I've been trying the hash partitioning system and it's been working really well. I have 100 partitions, but since I do hash(day()), it only gets ditributed on 31 partitions.

I would like to do two things:

1. Change the number of partitions to 150.
2. Hash in someway that all the data gets evenly ditributed on the 150 partitions in some way.

The data that I have is:
ipaddr1 (varchar), macaddr1 (varchar), macaddr2 (varchar), timestamp

How can I alter the current database? I have 200 Million entrys...

Options: ReplyQuote


Subject
Views
Written By
Posted
Using hash to partition
4572
June 04, 2007 05:17AM
2848
June 14, 2007 03:53PM
2644
July 04, 2007 07:09AM
2638
July 05, 2007 02:50AM


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.