MySQL Forums
Forum List  »  Partitioning

partitioning by highly skewed data
Posted by: Hiroshi Takenaka
Date: June 16, 2005 07:58AM

Will it be possible to partition one specific partiton further?

For example, we have a 1TB table. We want to partition it,
and spread over 10 * 140GB disks using one column.
But, unfortunately, 20% of records have NULL on that column.

It would be nice, if we can partiton those records further
by using another column or some random value.
I think it should be easy if user can define and use
a custom partitioning function.

Regards
Hiroshi

Options: ReplyQuote


Subject
Views
Written By
Posted
partitioning by highly skewed data
4309
June 16, 2005 07:58AM


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.